Rank function not showing consecutive

Joined
Apr 7, 2006
Messages
1
Reaction score
0
Hi All

I am using the rank function (yipee!) and most of it works fine. However, I would so dearly like the ranking results to show in consecutive order. For example, my current rankings show

1, 2, 2, followed by 4.

However I would like the results to show 1, 2, 2, followed by 3!!

Please can anyone help.

Many thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

RANK IN SEQUENCE 5
Rank Formula 1
How to Rank Name? 4
RANK function 5
Ties using Rank Function 3
RANK Function Modified? 12
Need help with RANK function 2
Rank function 5

Top