"Bob Phillips" wrote:
.. but doesn't this achieve the same result?
=IF(B20,RANK(B2,$B$2:$B$8),"")

Unlike : =IF(B20,C2+ROW()/10^10,""),
think the above would not be able to function
as the arb tie-breaker col in say, D2, filled down to D8
(there would be the same prob of duplicate ranks)

In my response, I had simply assumed the source table
includes the OP's rank formula in col C, and the suggested
3 col set-up (which is easily filled all the way down <g)
was merely an extension from there to drive the results out.
Cheers.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--