# 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

2. ## Re: Rank Problem

Try this:

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

3. ## Re: Rank Problem

Try this in C5:

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

4. ## Re: Rank Problem

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

5. ## Re: Rank Problem

You're welcome!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1