ExcelBanter - Multiple Column AutoFiltering

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Multiple Column AutoFiltering (https://www.excelbanter.com/excel-worksheet-functions/50057-multiple-column-autofiltering.html)

Peter Crickman

Multiple Column AutoFiltering

Hi,

I would like to be able to AutoFilter on two non-adjacent columns in a
spreadsheet. Is there any method to perform this task in Excel 2002 (XP)?
I get an error that the range is non-contiguous when I select two columns
separated by one or more columns.

Thanks in advance.

Alok

Highlight the entire area between column1 and column 2 and then apply Auto
Filter.
That should work.

Alok

"Peter Crickman" wrote:

Hi,

I would like to be able to AutoFilter on two non-adjacent columns in a
spreadsheet. Is there any method to perform this task in Excel 2002 (XP)?
I get an error that the range is non-contiguous when I select two columns
separated by one or more columns.

Thanks in advance.

All times are GMT +1. The time now is 10:47 AM.