Correct....RANK displays ties, but leaves a placeholder for the
"missing" value.

How would you pefer to handle exact duplicates?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=504956