Advanced Filter with Union of Ranges

's Computer Specifications

Is it possible to use a new range consisting of a union (of two different
ranges) within an advanced filter?

Thanks,
John

's Computer Specifications

No. Advanced filter works with a Table and a table is one contiguous range.

--
Regards,
Tom Ogilvy

"John" <(E-Mail Removed)> wrote in message
news:E0637124-4B69-4C4C-98C1-(E-Mail Removed)...
> Is it possible to use a new range consisting of a union (of two different
> ranges) within an advanced filter?
>
> Thanks,
> John

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Advanced Filter - Named Ranges	Bull	Microsoft Excel Worksheet Functions	1	30th Apr 2009 05:04 AM
Advanced Filter - Named Ranges	Bull	Microsoft Excel Programming	0	29th Apr 2009 08:01 PM
Advanced filtering of Union of named Ranges	El Cuarto Mago	Microsoft Excel Programming	1	27th Nov 2007 04:07 PM
Advanced Filter with Non-Contiguous Ranges	=?Utf-8?B?Sm9obg==?=	Microsoft Excel Programming	2	23rd Sep 2006 09:01 AM
Date ranges and advanced filter	=?Utf-8?B?cnQ=?=	Microsoft Excel Programming	3	1st Dec 2004 09:12 PM