Tuesday, July 28, 2015 – Permalink –
The Data Consolidation technique allows you to compare lists quickly and easily.
With the Consolidation technique, you can identify the number of duplicate entries in two or more lists without using a formula.
(not that it's easier, just that there are no formulas)
In the sheet there are two lists: List 1 is in column A (in cells A2:A10), and List 2 is in column C (in cells C2:C10).
The numbers appears in Column B are the totals of the list number in Column B. If the result = 1, the name appears in List 1 and does not appear in List 2. If the result = 2, the name appears in List 2 and does not appear in List 1. If the result = 3, the name appears in both lists (1+2=3). The action is not dynamic, so if you make changes, the Consolidation must be rerun.
From: "Mr Excel ON EXCEL"
Also see: John Walkenbach:
Comparing Two Lists With Conditional Formatting
Duplicate And Unique Items In Lists
Here's a more complex method: Microsoft Office Online:
Use Excel to compare two lists of data
What are Consolidated Worksheets ?
See all Topics excel
<Doug Klippert@ 3:12 AM
Comments: Post a Comment