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/