Link to home
Start Free TrialLog in
Avatar of adamchicago
adamchicago

asked on

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!!!!!!!!!!!!!
Avatar of Jorge Paulino
Jorge Paulino
Flag of Portugal image

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
Avatar of adamchicago
adamchicago

ASKER

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

Any other ideas?
ASKER CERTIFIED SOLUTION
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks