View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
fishy fishy is offline
external usenet poster
 
Posts: 39
Default 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...