Using advanced filter in combination with other filters

**ndenaro** · 07-10-2009, 02:02 PM

I am having some problems trying to filter a list to display exactly what I want to see. The list has one column of part numbers, a second with due dates, and then another with quantity. I want to use an advanced filter on the part numbers to only look at unique entries. Then I want to filter that list using a custom filter on the due dates to only view those due within a certain period. So ultimately I want to view only unique entries due during a given period.

I am able to apply one filter, but when I go to apply the second, the second filter removes the first. For example once I have filtered out duplicates, when I try to filter based on date all of the duplicates return. Is there any way to get around this?

Thanks for any help.

**JBeaucaire** · 07-10-2009, 02:31 PM

Edit: Nope, I was wrong, doesn't work for me either.

You'll probably have to NOT filter in place.

**ndenaro** · 07-10-2009, 02:47 PM

Even when filtering not in place, the advanced filter removes by original filter. Also, even if it didn't remove my first filter, the new column would not line up with the rest of the table.

**JBeaucaire** · 07-10-2009, 02:51 PM

No, what I mean is you'll have to do step #1, then copy the visible data over to another spot/sheet where you can apply your AdvFilter. You can't do it in the same place as the original AutoFilter.

**ndenaro** · 07-10-2009, 03:02 PM

gotcha, yes that would work

**JBeaucaire** · 07-10-2009, 03:18 PM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)

**ndenaro** · 07-13-2009, 07:51 AM

If this is definately the only way to accomplish this then thats that, I would prefer to filter without having to copy and paste to another sheet but if we can confirm that it is necessary than I would call it solved. Thank you for all of your help.