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:

=IF(S14>0,RANK(S14,$S$14:$S$48,1),"")

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.

Cheers.

Aladin


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

Re: Rank question cont'd

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