Can a column of number be assigned an ID number?

[AceForSale]

Is there a way to assign an ID number to a column of numbers, the number would be assigned based off its largest to smallest number?

Example:

(Column of numbers)
20
5
2
400
600
95
21

(Column of numbers with ID number in Col B)
20 5
5 6
2 7
400 2
600 1
95 3
21 4

Is this possible to do in excel?

[Glenn Kennedy]

If your numbers are in A2 to A8, copied down:

=RANK(A2,$A$2:$A$8)

[Pete_UK]

For the examples you posted, you can put this formula in B1:

=RANK(A1,A$1:A$7)

then copy down.

Hope this helps.

Pete

[AceForSale]

Glenn and Pete, Thank you. I didn't know about the Rank function. This will be a very useful function in the future and it worked for what I'm trying to do now.

[Glenn Kennedy]

One word of "warning"... can there be tied values? if so, how do you want them to be handled?

[AceForSale]

Thank you very much