I have 2 numbers, both 18.19 in value, but the rank function treats them differently. Usually the rank function will assign the same rank to numbers of the same value, but here it assigns a different value, which is wrecking my otherwise nicely working VBA script. Out of thousands of trials I've only seen this once, in this instance. Here is the data:
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
The second 2 columns are the first columns copy and pasted. Then, all I did was copy the first instance of 18.19 and paste it into the second instance. Now the rank function treats them properly as equals. Why were they not equal before?? I'm so lost I'd really appreciate any insight, even guesses. Thanks!
B | C | D | E | F | G | H | I | J | |
---|---|---|---|---|---|---|---|---|---|
2 | Data | Rank | Data | Rank | |||||
3 | 18.26 | 2.00 | =B4=B9 | 18.26 | 2.00 | =G4=G9 | |||
4 | 18.19 | 3.00 | TRUE | 18.19 | 3.00 | TRUE | |||
5 | 11.65 | 6.00 | 11.65 | 6.00 | |||||
6 | 15.18 | 5.00 | 15.18 | 5.00 | |||||
7 | 18.19 | 4.00 | 18.19 | 3.00 | |||||
8 | 24.42 | 1.00 | 24.42 | 1.00 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
<tbody>
</tbody>
The second 2 columns are the first columns copy and pasted. Then, all I did was copy the first instance of 18.19 and paste it into the second instance. Now the rank function treats them properly as equals. Why were they not equal before?? I'm so lost I'd really appreciate any insight, even guesses. Thanks!
Last edited: