Consolidate 3 lists with duplicates into one list
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 -- Re |
Consolidate 3 lists with duplicates into one list
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. -- Regards, PJ Please rate this post using the vote buttons if it was helpful. "Re" wrote: 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 -- Re |
All times are GMT +1. The time now is 08:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com