Afternoon all, hopefully a simple question. I have a formula in a column which works out the fastest time that a competitor posts out of several runs and then am trying to get another column to then rank these times from fastest to slowest (which i have achieved). The problem i have is that when i use either of the two formulas below, because the cell i am referencing has a formula in it, the rank formula is showing a 'true' result because the cell in question has something in it (a formula) whereas i need it to remain blank as there isn't a time in it.
=RANK(V14,$V$11:$V$39,1)
=IF(V11="","",RANK(V11,$V$11:$V$38)+COUNTIF(V11,$V$11:$V$11)-1)
Look forward to you thoughts.
TJ
Bookmarks