Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete duplicates: Sum & Consolidate | Excel Worksheet Functions | |||
Delete Duplicates: Sum values & Consolidate | Excel Discussion (Misc queries) | |||
Consolidate Lists from Multiple Sheets on another Sheet | Excel Worksheet Functions | |||
Consolidate multiple lists, with auto-update | Excel Discussion (Misc queries) | |||
How to consolidate several Excel lists into one? | Excel Discussion (Misc queries) |