Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

( NM ) Aladin..check your mail..

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

Check out our Excel Resources

Rank question cont'd

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

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

Re: Rank question cont'd

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

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.