Lawrence,

See the Unique Ranks section at http://www.cpearson.com/excel/rank.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Lawrence" wrote in message
...

Thanks RADO

but RANK gives duplicate numbers the same rank. The presence of
duplicate numbers affects the ranks of subsequent numbers. For example,
in a list of integers, if the number 10 appears twice and has a rank of
5, then 11 would have a rank of 7 (no number would have a rank of 6).

Please advise.


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