Ask Your Question
0

Rank : how to prevent duplicates.

asked 2018-09-21 16:22:34 +0200

JG101 gravatar image

updated 2018-09-28 14:25:04 +0200

=RANK(T5,$T$5:$T$43,0)

How do I fix so I do not have duplicates.

thank you for any help anyone provides

edit retag flag offensive close merge delete

Comments

What duplicates? We don't know your data, we don't know your results. RANK() just determines the rank of a value within a given set of data.

erAck gravatar imageerAck ( 2018-09-22 00:38:37 +0200 )edit

If you have duplicates / repetitions, you have duplicates. No fix insofar. The exactly same value occurring more than once in a sequence of numbers has the same rank on every occurrence. the higher ranks are omitted as often as a repetition occurs and the next number to be ranked in the chosen order gets the first rank number unused so far. That's the way ranking is done everywhere. If you need disambiguation, you need to specify in what way. It cannot be done for sets.

Lupp gravatar imageLupp ( 2018-09-28 15:41:46 +0200 )edit

Disambiguation of ranks always requires to introduce a "second key of order".
If the numbers to rank are taken from a cell range which is part of a single column e.g. you can use the row number for disambiguation in many cases. You will have to assure something about the numeric range and the range of row numbers as well to allow for a reliable solution.

Lupp gravatar imageLupp ( 2018-09-28 15:48:34 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2018-09-22 00:42:34 +0200

m.a.riosv gravatar image

Help RANK.EQ

Perhaps it's what you are looking for.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-09-21 16:22:34 +0200

Seen: 43 times

Last updated: Sep 28