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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Consolidation formula 1
Consolidate Lists from Multiple Sheets on another Sheet 9
Sumproduct - meet multiple criteria from a list 6
Consolidate, Lookup and Sum from dates to months 3
combining several lists into one? 1
SUMPRODUCT 1
dynamically sorted list with duplicates 5
Problem with fields in PivotTable with multiple consolidation rang 2

Back
Top