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
