Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Top X,Middle Y,Bottom Z percent Records
Hi,
can anyone has answer for the following scenario. How will I get Top 20(say for example 20), middle 20, bottom 20 records in an excel sheet supposing there are 60 records. Any idea for generalized one? (i.e) If I specify top x % records then it should return the top x % records and as the same way if I specify bottom y % then it should return the bottom y % of the total records. Thanks in Advance, Bala |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning Bottom 10 Percent in another spreadsheet | Excel Worksheet Functions | |||
Returning Bottom 10 Percent in another spreadsheet | Excel Worksheet Functions | |||
Conditional Formatting Bottom 'n' percent | Excel Discussion (Misc queries) | |||
Need Percent of Records | New Users to Excel | |||
Z Chart i.e. top rolling annual bottom rolling monthly middle cum. | Excel Worksheet Functions |