How do I differentiate between duplicate ranks?

P

Pez

I need to graph information that is based on a ranked table. A vlookup
function finds information based on ranks 1-15 from one column, however when
the data is the same Excel assigns duplicate ranks. This then does not allow
an average or trend line to be calculated accurately, because the missing
data (for example, rank 4) returns a score of #N/A due to there being two
scores for rank 3, leaving the next rank available being 5.
 
J

JMB

Assuming the scores are in A1:A7, enter this in cell B1 and copy down.

=RANK(A1,A$1:A$7)+COUNTIF(A$1:A1,A1)-1
 

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 based on 2 categories 6
sorting with RANK/VLOOKUP (problem with equal ranks) 2
RANK bug: same values get different ranks 6
Ranking In Access 0
Calculating an average of data between two dates 1
How do I return multiple values from a single number in a list? 1
what function/formula do I use? 2
IF statements with multiple criteria 2

Top