Rank

  • Thread starter Thread starter David Barrett
  • Start date Start date
D

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
 
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)
 
Back
Top