MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Question about Rank Formula

Posted by IGoR on July 14, 2001 7:56 PM

This is my formula : =RANK($E$1:$E$12,$E$1:$E$12,1)

but when there is no data entered on the required
cell to be rank, it will show #N/A or other number.
How can the rank formula will show nothing when there
is no data entered. Thanks in advance

Posted by Aladin Akyurek on July 14, 2001 11:20 PM

Make that




Posted by IgOR on July 15, 2001 7:35 AM