Wednesday, October 01, 2008 – 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)
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.
"Mr Excel ON EXCEL" (Holy Macro Books)
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
<Doug Klippert@ 4:16 AM
Comments: Post a Comment