Hi
see:
http://www.xldynamic.com/source/xld.RANK.html
and
http://www.cpearson.com/excel/rank.htm
--
Regards
Frank Kabel
Frankfurt, Germany
"laidbackgraham" schrieb im
Newsbeitrag ...
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.