Percentage ranges within data range - help needed
I have a range of numerical data in a column sorted. I ned to rank these for
an "if" arguement.
I need to know the top 5% rated (A), next 10% (B), next 60% (C) then the
last 25% (D).
The data volumes are varied between 5 rows and 21 rows and the values
normally are anywhere between 50 and 200.
I have tried various approaches but am probably missing an obvious one...
|