|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 27th, 2008, 06:27 PM
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
May 27th, 2008, 10:05 PM
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
May 28th, 2008, 03:11 PM
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
May 28th, 2008, 03:44 PM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
