Hi All,

Col# A B D
1 5 Prod1 Prod2
2 10 Prod2 Prod4
3 4 Prod3 Prod1
4 10 Prod4 Prod3
5 3 Prod5 Prod5
6 3 Prod6 Prod6

There are 2 Columns on a worksheet-Column A and Column B. In Column A are
values and in Column B are product names. Need a formula to get the names
from Column B and to put them in Column D in the next order: In CellD1 is the
name of the first product with the largest value in column A(in the example
this is Prod2), in Cell D2 is the name of the second largest value in column
A(in the example this is Prod4) and so on.
I tried this formula

=INDEX(B:B,MATCH(LARGE($A:$A,ROWS($B$1:B1)),$A:$A, 0))

But it doesnt work because often in column A there are 2 or 3 cells with
the same largest value (in the example above cells A2 and A4) and in this
case the formula gives me wrong results.
I think this task can be done with array formula but cant manage to create
it by myself.


Tim