Filter and save result

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

annoni - 27 May 2008 18:27 GMT

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 to this Message

Peo Sjoblom - 27 May 2008 22:05 GMT

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

Signature

Regards,

Peo Sjoblom

> 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 to this Message

annoni - 28 May 2008 15:11 GMT

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?

> Paste it unto a new sheet and discard the old, or reverse the filter so you
> gat everything except what
[quoted text clipped - 3 lines]
> > on
> > the same sheet and discard the rest? Please help...thanks.

Reply to this Message

Peo Sjoblom - 28 May 2008 15:44 GMT

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

Signature

Regards,

Peo Sjoblom

> Thanks...Now I have a question about reverse filter...Is there a short cut
> or
[quoted text clipped - 10 lines]
>> > on
>> > the same sheet and discard the rest? Please help...thanks.

Reply to this Message