I Need Help

  • Thread starter Thread starter Mch
  • Start date Start date
M

Mch

When using rank it assigns duplicates the next higher number in rank.Ho
do you avoid thi
 
Here's a possible solution:

=RANK(C7,C$7:C$16)+COUNTIF(C$7:C7,C7)-1


Fabl
 
You must log in or register to reply here.

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

USB Com ports 6
How to finding student Rank and How to upload bulk marks of each student at a time. 1
RANK Function 3
Problems Rank Ordering 4
RANK not resulting as hoped 8
Rank Function - Ranking Array Size Limit 1
RANK and CORRELATION 7
Ranking query 2

Back
Top