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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Top X,Middle Y,Bottom Z percent Records
The PERCENTRANK worksheet function will rank them for you by percent. I am
not sure what you want to do when you select them (copy them somewhere?) but you can use the results of this function to easily find the records in any percent range. -- - K Dales "Bala" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Top X,Middle Y,Bottom Z percent Records
Look at Data=Autofilter
otherwise, you would probably need to use a dummy column containing a formula to specify which group that row goes in - then use the autofilter no that column or sort. Of course a macro is always an option as well. -- Regards, Tom Ogilvy "Bala" wrote: 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 |
Reply |
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 |