laidbackgraham Wrote:
When I use rank to identify the Top 50, I sometimes get a tie, I would
like
to be able to always have a rank of 1,2,3,4,etc even if the standard
rank
function generated 1,2,2,4 (i.e. although the data has actually got 2
equal
values, I would like to distinguish them, by having one ranked at 2 and
one
ranked at 3.

Looks like you're constructing a Top 50 list. That also requires making
a distinction between ties. Here is an example of constructing a Top N
list:

http://tinyurl.com/22x6k


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=274557