stackErr
Reputation: 4170
Compare two lists in excel and find uniques and dupes
There are two lists I need to compare, see the below pic:
What I want to do is compare if each ID AND Option in left list exists or not in the right list. I tried to use VLOOKUP and COUNTIF but I dont know how to deal with the AND condition(ID AND Option) in both of them.
How can I do this?
Upvotes: 0
Views: 10085
Answers (1)
Related Questions
- Ignore Duplicates and Create New List of Unique Values in Excel
- Excel Comparing List 2(current) against List 1(Existing) for duplicates and new items
- Check if a list have the same element in Excel
- Excel - List return distinct data from other column with duplicate values
- Extracting duplicates from a list in a cell
- Excel - Two key value lists - Locate where Key is different but value is the same
- Compare 2 lists in Excel ?
- Formula to find unique data in list - excel
- I want to compare two lists in different worksheets in Excel to locate any duplicates
- Finding Unique data in a list