M
Mac
I have a spread sheet (sheet1) with many coloumns (abt
15). In the first coloumn (from A2) is productname and in
second coloumn (from b2) Price and third coloumn I have
the qty from (c3) etc....
In sheet2 I pulled the largest quantity in one coloum and
largest price in another coloumn using Large(Price,x) and
Large(qty,x). Now i need to get the corresponding
productname in the left of the each results. I know to do
it using match function, but there are few duplicate
prices and duplicate quantities. So match always giving
the first value, not the exact product name.
Is there a way to solve this?? Any help hightly
appreciated.
Marc
15). In the first coloumn (from A2) is productname and in
second coloumn (from b2) Price and third coloumn I have
the qty from (c3) etc....
In sheet2 I pulled the largest quantity in one coloum and
largest price in another coloumn using Large(Price,x) and
Large(qty,x). Now i need to get the corresponding
productname in the left of the each results. I know to do
it using match function, but there are few duplicate
prices and duplicate quantities. So match always giving
the first value, not the exact product name.
Is there a way to solve this?? Any help hightly
appreciated.
Marc