ChatterBank3 mins ago
Excel - 2 Lists - I want to find unique records!
1 Answers
I have 2 lists of numbers in Excel (6 digits each number).
Some of these numbers appear in both lists.
Some numbers only appear in one list.
I would like to cross-reference these lists and create another list of the singular, unique records.
I have done this before but cannot remember how I did it!
Sorry, posted this in 'technology' general too...forget the 'computer' drop down here!
Some of these numbers appear in both lists.
Some numbers only appear in one list.
I would like to cross-reference these lists and create another list of the singular, unique records.
I have done this before but cannot remember how I did it!
Sorry, posted this in 'technology' general too...forget the 'computer' drop down here!
Answers
Best Answer
No best answer has yet been selected by funkylad20. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.