Advanced Filter problems - returning more than expected

LeahWright

New Member
Joined
Jun 14, 2004
Messages
39
Have two three tabs in a workbook.
Tab 1 - Used to display results of Advanced Filter

Tab 2 - Contains Criteria Range for Advanced Filter (90 rows + header row)
hvo1f8.png

Tab 3 - Contains List Range for Advanced Filter (5450 rows + header row)

5e7jtu.png

I want to find all rows in Tab 3 that contain the same Case IDs that appear on Tab 2 in column B and copy columns A:K to Tab 1. Some Case IDs appear once and some may appear 20 times. I want all instances to copy.

I set Advanced Filter up as such:
v4mb15.png


The problem is, all 5450 rows from Tab 3 are being copied to the results tab, instead of only the rows that contain a value that appears on Tab 2. Am I missing a step?
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Peter Thompson

Active Member
Joined
Dec 15, 2008
Messages
262
I think that its because the header name in the criteria is different from the header in the data so the advanced filter has nothing to filter on.
 

LeahWright

New Member
Joined
Jun 14, 2004
Messages
39
I changed the header row so the column headings are identical and I am still getting the same surplus results. :confused:
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,056
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
You have specified entire columns for your criteria range. If you have blank rows in the criteria range you will get all records back, so you need to adjust that.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,232
Messages
5,594,962
Members
413,954
Latest member
mrsandy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top