Thanks, Biff.

I can see how your formula works, but it results in rankings between 1
and 6.

I probably wasn't clear enough in my original explanation - I need
these people to be at the bottom of the list, ranked in order of their
budgets if they have not yet made any sales. In other words, they would
have a rank of 70-75 (75 being the total number of rows in the RANK
array), instead of all having the same rank of 70, which my RANK
formula calculates.


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