Compare 6 values

[barnicoate]

Hi,

I need to compare a list of values in the attached spreadsheet; In column F7:F12 are the values in percentiles.

I need to grade them into 1st, 2nd and 3rd in order from most to least.

I have already used MAX to find the 1st value and a Vlookup to show other data..

Thank you for any help

[NBVC]

Try RANK()

eg

=RANK(F7,$F$7:$F$12)

copied down

[barnicoate]

Thank you NBVC.

Tried your suggestion but found another solution in another forum.

=INDEX($AV$7:$AV$12,MATCH(LARGE(AT$7:AT$12,1),AT$7:AT$12,0))

This allowed me to sort and rank the data, by changing the 1 to 2 or 3 i was able to rank my data.

Many thanks for pointing me in the right direction.