Ok, so you want those ranks to correlate to the other ranks?

So if the lowest non-zero rank is 50 you then want the "zeros" to start from
that point and be unique?

What about duplicate ranks for the others? That's OK but it's not OK for
people with no sale?

Biff

"tuph" wrote in message
...

Hmmm - could do, but then it wouldn't be dynamic and change the ranking
of the remaining people when one of them makes a sale.


--
tuph
------------------------------------------------------------------------
tuph's Profile:
http://www.excelforum.com/member.php...o&userid=31390
View this thread: http://www.excelforum.com/showthread...hreadid=569284