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!!!!!!!!!!!!!
Need to rank a column of numbers (column B) based on if another column has an "X" in it (column C)
Thank you!!!!!!!!!!!!!
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
=IF(C1="x",B1,"") ... drag down as required
Then base your rank function on the helper column.
Chris
ASKER
I tried the link ideas but they don't work for 2003...but they're close to the solution.
Any other ideas?
Any other ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
http://www.mrexcel.com/forum/showthread.php?t=82479
http://whatapalaver.co.uk/2009/09/conditional-ranking-in-excel-rankif-using-sumproduct/