Worked for me!!
Thanks.

Paul Sheppard Wrote:
Hi cardingtr

=IF(B3="","",RANK(B3,$B$3:$B$12,1)), worked ok for me, anyway try this
instead

=IF(ISNA(RANK(B3,$B$3:$B$12,1)),"",RANK(B3,$B$3:$B $12,1))


--
cardingtr
------------------------------------------------------------------------
cardingtr's Profile: http://www.excelforum.com/member.php...o&userid=27027
View this thread: http://www.excelforum.com/showthread...hreadid=465810