Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Filter and save result
After filtering a list, how do I save only the filtered result "as it is" on
the same sheet and discard the rest? Please help...thanks. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Filter and save result
Paste it unto a new sheet and discard the old, or reverse the filter so you
gat everything except what you intended to filter for and then delete all rows -- Regards, Peo Sjoblom "annoni" wrote in message ... After filtering a list, how do I save only the filtered result "as it is" on the same sheet and discard the rest? Please help...thanks. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Filter and save result
Thanks...Now I have a question about reverse filter...Is there a short cut or
a formula to do this or do I have to manually filter and delete "reverse" items? "Peo Sjoblom" wrote: Paste it unto a new sheet and discard the old, or reverse the filter so you gat everything except what you intended to filter for and then delete all rows -- Regards, Peo Sjoblom "annoni" wrote in message ... After filtering a list, how do I save only the filtered result "as it is" on the same sheet and discard the rest? Please help...thanks. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Filter and save result
There is nothing built in, you would need for instance if you
previously filtered for records greater than 200, then you would need to use less than or equal to 200, select the range and delete them. You would probably be better off using the advanced filter where you can filter to another sheet http://www.contextures.com/xladvfilter01.html look at the extract data to another sheet Finally you could record a macro to automate it -- Regards, Peo Sjoblom "annoni" wrote in message ... Thanks...Now I have a question about reverse filter...Is there a short cut or a formula to do this or do I have to manually filter and delete "reverse" items? "Peo Sjoblom" wrote: Paste it unto a new sheet and discard the old, or reverse the filter so you gat everything except what you intended to filter for and then delete all rows -- Regards, Peo Sjoblom "annoni" wrote in message ... After filtering a list, how do I save only the filtered result "as it is" on the same sheet and discard the rest? Please help...thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filter and save result | Excel Discussion (Misc queries) | |||
how do i auto copy the result of a filter | Excel Worksheet Functions | |||
Filter or sort a macro result | Excel Discussion (Misc queries) | |||
save filter | Excel Worksheet Functions | |||
save auto filter | Excel Discussion (Misc queries) |