Dear all,

I would like to have you help.

For instance, I have a group of numbers (not in sequence) in Column A.
In Column B, I would like to classific the biggest number to be "1",
second biggest to be "2", and so on. However, I don't want to just
"sort" Column A and use "max" to find the biggest. Please help to
suggest some more smart way.

Someting like below.
A____B
10___5
62___1
39___2
18___4
27___3
27___3
8____6


Thanks a lot.
Lawrence


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/