In Column A, I have 7000 rows of unique bore numbers. In Column D, I have 800 rows of bore numbers.(Column B & C contain data relating to Column A).

I want to filter the bore numbers in Column A to only include those bore numbers that are in Column D.

I have tried to use the advanced filter function in Excel, with my range selected as the 7000 rows in Column A and my criteria range as the 800 rows in Column D but the result just returns all the numbers in Column A.

Sample data:

enter image description here

  • 1
    The link does not appear. Please click edit and either give us an example, or a weblink we can use to see the data. – K7AAY Dec 27 '18 at 21:40

Here is a non-filtering answer:

Paste this into E2:


and this into F2:


Then copy E2 and F2 and paste down your 800 rows.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.