Consolidate 3 lists with duplicates into one list

  • Thread starter Thread starter Re
  • Start date Start date
R

Re

Hi,

How do I take 3 lists with similar but not exact information and also
compare and consolidate those lists into one list. For example:

A B A B A B
Chix 20 Lio 10 App 5
App 10 Bob 15 Lio 10
Lio 12 Chix 20 Bob 10
Chix 10

Does that make sense?

Thx, Re
 
The simplest thing to do is to create one column with all the data:
Chix 20
App 10
Lio 12
Lio 10
Bob 15
Chix 20
App 5
Lio 10
Bob 10
Chix 10

Sort it by A then B:
App 5
App 10
Bob 10
Bob 15
Chix 10
Chix 20
Chix 20
Lio 10
Lio 10
Lio 12

Enter this formula into column C:
=IF(A2&B2=A1&B1,1,0)

And all of your duplicate values will show as 1. You can filter those out,
or resort on column C and delete them.

Hope this helps.
 
Back
Top