| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| percentage range | Excel Worksheet Functions | |||
| Percentage within a range | Excel Worksheet Functions | |||
| x y scatter chart series ranges reset to x(range) = y(range) | Charts and Charting in Excel | |||
| Displaying percentage in ranges in pivot table | Excel Worksheet Functions | |||
| Percentage function needed | Excel Worksheet Functions | |||
Threaded Mode
