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.
