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
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
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star iconat the bottom left of my post.
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!
'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.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.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks