Excel 2003: Need Rankif Formula

Can someone help figure out a Rankif formula?

Need to rank a column of numbers (column B) based on if another column has an "X" in it (column C)

Thank you!!!!!!!!!!!!!

Microsoft Excel

Last Comment

adamchicago

8/22/2022 - Mon

Jorge Paulino

5/13/2011

Check this solutions:

http://www.mrexcel.com/forum/showthread.php?t=82479
http://whatapalaver.co.uk/2009/09/conditional-ranking-in-excel-rankif-using-sumproduct/

Chris Bottomley

5/13/2011

Of you add a helper column ... for example D and then in there use:

=IF(C1="x",B1,"") ... drag down as required

Then base your rank function on the helper column.

Chris

adamchicago

5/13/2011

ASKER

I tried the link ideas but they don't work for 2003...but they're close to the solution.

Any other ideas?

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!

Walt Forbes

ASKER CERTIFIED SOLUTION

barry houdini

5/14/2011

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.