Consolidate 3 lists with duplicates into one list

[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

 

[PJFry]

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.