# Rank Problem

1. ## Rank Problem

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  Register To Reply

2. ## Re: Rank Problem

Try this:

=IF(B21=0,"",RANK(B21,\$B\$21:\$B\$30,1))  Register To Reply

3. ## Re: Rank Problem

Try this in C5:

=IF(B5=0,"",COUNTIFS(\$B\$5:\$B\$14,">0",\$B\$5:\$B\$14,"<"&B5)+1)  Register To Reply

4. ## Re: Rank Problem

There was me thinking more complex when i needed more simple! Thanks for the easy fix!  Register To Reply

5. ## Re: Rank Problem

You're welcome!   Register To Reply