ExcelBanter - Advanced Filter with Union of Ranges

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Advanced Filter with Union of Ranges (https://www.excelbanter.com/excel-programming/384426-advanced-filter-union-ranges.html)

John

Advanced Filter with Union of Ranges

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

Thanks,
John

Tom Ogilvy

Advanced Filter with Union of Ranges

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

--
Regards,
Tom Ogilvy

"John" wrote in message
...
Is it possible to use a new range consisting of a union (of two different
ranges) within an advanced filter?

Thanks,
John

All times are GMT +1. The time now is 05:07 PM.