Based on rank fill in value

[polska2180]

Hi I have column F with $ in it and column G with Rank lowest to highest. So if the $ amount is the highest the rank would be 1 and next highest rank would be 2.

What I would like is in H2:h42 to look at highest rank and populate the amount from column H. So no matter what order F and G are in I want to have column H always go from 1...42.

Thanks for the help.

 

[mart37]

You can use LARGE or INDEX-MATCH in combination with ROW.

 

[Fluff]

You could also use

=SORT(F2:F42,,-1)

 

[polska2180]

You could also use

=SORT(F2:F42,,-1)

Perfect...ty

 

[Fluff]

Glad we could help & thanks for the feedback.