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

=IF(ISBLANK(E1),"",RANK(E1,$E$1:$E$12,1))

Aladin

=============

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