Rank

[David Barrett]

Why does the rank function sometimes give different
rankings to equal values, more specifically, where a large
number of rows within a table equal 100%?
I can't seem to fix it.
David Barrett

 

[Frank Kabel]

Hi David
probably the numbers are not identical but only looks like this. E.g.
you show only the first two decimals. Internally Excel still calculates
with all significant decimals.
One way (if you are caluclation percentages) would be to round your
numbers:
e.g. ROUND(your_formula,2)