Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Advanced filter not working

Tags:

excel

filter

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?

like image 744
user3182532 Avatar asked Sep 26 '17 07:09

user3182532


1 Answers

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.

like image 118
zipa Avatar answered Oct 06 '22 07:10

zipa