Advanced filter not working

Question

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?

Answer 1

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.