Please I am writing a spreadsheet and I have a range that contains formula (=SUM(E2F2G2H2) and I want to rank the final calculated values in the range using = Rank(I2,$I$2:$i$200), I want cells in the range with no calculated value yet to be blank cells in the column containing the ranks. Please help!!!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Excluding cells that contains formula but no calculated value from ranking (use RANK) until calculated value are in the cell
Similar threads
- Solved
- Solved
