Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

If you are going to copy the filtered data to some other location then there is no need to use formula. Instead you can use the Advanced filter.

Select the table of columns A-F. Then from the menu choose "Data", "More Filters", "Advanced Filters..." and then for the filter criteria select the list in column G and click OK.

You can then copy the now filtered data and paste it to a target range of cells.

Reset the filter on your table using "Data", "More Filters", "Reset Filter".

If you are going to copy the filtered data to some other location then there is no need to use formula. Instead you can use the Advanced filter.

Select the table of columns A-F. Then from the menu choose "Data", "More Filters", "Advanced Filters..." and then for the filter criteria select the list in column G and click OK.

You can then copy the now filtered data and paste it to a target range of cells.

Reset the filter on your table using "Data", "More Filters", "Reset Filter".

Note the heading for column G should be the same as the heading for the table column to be filtered.