CODEWITHSUNDEEP
excelfilter
user3182532
user3182532

Reputation: 1127

Advanced filter not working

I'm trying to filter a column based on values in another column. I click on the column that I want to filter (I click on "A" in sheet 1). The whole column is selected. I click on advanced filter. I click the button to select the second column. I go to sheet 2 and click on "A". That's my column with the filter criteria. I click OK and nothing happens. All records are returned. How the heck does that thing work?

EDIT

I finally found out why. The column that you use as filter criteria has to have the same header name as the column that you want to filter ... that's so stupid -_- why wouldn't you allow someone to filter a column based on a simple list of values without header name?

Upvotes: 10

Views: 26816

Answers (1)

zipa
zipa

Reputation: 27869

You can use filter based on a column B that will have formula:

=COUNTIF(Sheet2!A:A,A2)

Now just filter column B all values that are greater than 0.

As for your issue with advanced filter just select data without header row when applying advanced filter.

Upvotes: 3

Related Questions