Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hiding Rows Based on Percentile
Hello, I have recently searched for help on the Percentile function,
and found a lot of what I was looking for. (at least I now understand it). However, now that I have calculated the percentile on my sheet, I want to filer the list of rows so that only those in the nth percentile are shown on the sheet. How would I go about doing this ? (I'm assuming VBA code would need to be used, but I'm not that great with it yet) Cheers. J. |
#2
|
|||
|
|||
Numbers of users go the "helper-column" route, that is
Insert a new column (which you can later hide) and enter in say cell G1 an If() statement something like =if(F1.75,"Select-Yes","Select-No") then use Data - Auto-Filter on your table selecting only the Select-Yes records. Hope this helps// "Jonny" wrote in message m... Hello, I have recently searched for help on the Percentile function, and found a lot of what I was looking for. (at least I now understand it). However, now that I have calculated the percentile on my sheet, I want to filer the list of rows so that only those in the nth percentile are shown on the sheet. How would I go about doing this ? (I'm assuming VBA code would need to be used, but I'm not that great with it yet) Cheers. J. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
Copying Rows when hiding other rows | Excel Worksheet Functions | |||
Hiding rows based on date | Excel Worksheet Functions | |||
Count rows based on multiple criteria | Excel Worksheet Functions |