CODEWITHSUNDEEP
excel
Revious
Revious

Reputation: 8156

Excel find records which are not matched in another list

I've a first table (let's call it A) with a column URL which contains some values which are not unique.

There is a second table (let's call it B) which is similar to A.

I want to evidence the records of A which have an URL that is not on B.

Upvotes: 0

Views: 53

Answers (1)

ttaaoossuu
ttaaoossuu

Reputation: 7894

Say, your columns A:A and B:B have URL lists you want to compare. Add column headers in top row, if you have none. Then write this formula in C2 and drag it down:

=COUNTIF($B:$B,$A1)=0

Then select the whole column C:C by clicking on gray C header above topmost cell and apply filter by pressing CTRL+SHIFT+L. Filter by TRUE - these are the values you need.

Upvotes: 1

Related Questions