Use advanced filter and autofilter in conjunction

[banana-pumpkin]

Hi,

I have a long list of data to which I've applied the Advanced filter to show only unique records. I now want to use Autofilter to show subsets of that data, but when I click Autofilter, Excel removes the original Advanced filter criterion, i.e. I have hundreds of duplicate values again.

Is there a way of filtering only the unique records?

Thanks

[Richard Buttrey]

Hi,

Have you considered first using Advanced filter to copy the unique items and any other columns you want to a new area and then using AutoFilter on that new area.

I don't think you can combine Advanced and Auto filter in one performance - famous last words....

HTH

[banana-pumpkin]

Thanks Richard - I would do that, but the trouble is that I'm trying to design a spreadsheet which will be updated weekly by someone who knows very little about Excel. I'm sure I can find a workaround, though!

[JBeaucaire]

'SHEET1 TO MANY SHEETS

I have a macro that may be "ready to use" for parsing rows of data from one sheet to many sheets named for the same values.

Sheet1 to Many Sheets

It not only can parse the rows, it can create the sheets if they are missing.

This sounds like this may give you what you want...it will first identify all the unique values in a single column (column A is the default) and then create a separate sheet listing all the items for each unique value. Give it a try. This technique is an Advanced Filter followed by an Autofilter.