MrExcel Publishing
Your One Stop for Excel Tips & Solutions

( NM ) Aladin..check your mail..

Posted by IgOR on July 15, 2001 8:50 AM


Posted by Aladin Akyurek on July 15, 2001 3:04 PM

Rank question cont'd

Change the condition of the IF-part of the formula from ISBLANK to:


The reason why ISBLANK(S14) as condition of IF will not work is that the range S14:S48 contains formulas which make that all cells in the range are nonblank cells.

The suggested modification expects positive numbers above 0 in S14:S48.



Posted by IgOr on July 15, 2001 3:56 PM

Re: Rank question cont'd

You save d me again Aladin..Zillion thanks..regards