Search column for highest value, then second highest, etc.

Hi All,

I have a set of numeric values in a column that will vary between 0 and 80. Some columns may have the same number more than once.

I would like to create nominal numeric values in the next column to represent the ranking of the values in the previous column with 1= highest value, 2=next highest value etc.

It would be great to adjust for ties, i.e., two top values of 28 would result in two "1s" no "2s," rank would continue with "3"

I know I can do this with a sort but we will have hundreds of these!

I have attached a sample file.

Thanks.

Check out the RANK function in excel help