» Comparing Three or More Lists in Microsoft Excel
CATEGORY - Excel Consolidating
VERSION - All Microsoft Excel Versions
Use the technique described at the tip "Comparing Lists in Microsoft Excel" (view tip) and then paste three lists one list below the other.Note
the list number should be factors of 2 (or any other mathematical combination that you choose).
- For List 1, use 2^0 or the number 1.
- For List 2, use 2^1 or the number 2.
- For List 3, use 2^2 or the number 4.
- 1,2,4 = the name appears in only one list.
- 3,5,6 = the name appears in two lists, 3=2+1, 5=4+1,6=2+4.
- 7 = the name appears in all three lists.
Book Store:
Recommended Books:
- Marketing Plan: A Handbook with Marketing Plan
- How to Use Financial Statements: A Guide to Understanding the Numbers
- How to Pay Zero Taxes (Annual)
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Guide to Financial Reporting and Analysis
- Personal Finance for Dummies
No comments have been submitted.
