CODEWITHSUNDEEP
excelexcel-formulainventory-management
The Noc
The Noc

Reputation: 1

Massive excel columns - Isolating unique SKU ID

I have 2 large columns in excel with each column representing a SKU ID. Column A is the Old List found on our web site. Column B is the new list

I need a formula that will allow me to see what SKU ID are not found in the new list so we can then delete them from the pile.

Any help will be great. I am racking my head trying to solve this.

Phil

Upvotes: 0

Views: 43

Answers (2)

teylyn
teylyn

Reputation: 35970

Or with Countif(), which will be faster than the exact Match wrapped in IsError:

=if(Countif(A:A,B1),"found","not found")

If you sort by column A, Match can be fast, too, using an approximate match.

=IF(INDEX(A:A,MATCH(B1,A:A,1))=B1,"found","not found")

Upvotes: 1

Tim Wilkinson
Tim Wilkinson

Reputation: 3791

Many ways to do this, this is just one of many options:

=IF(NOT(ISERROR(MATCH(B1,A:A, 0))), "FOUND", "NOT FOUND")

Upvotes: 1

Related Questions