» Comparing Lists Using the COUNTIF Formula
CATEGORY - Counting
VERSION - All Microsoft Excel Versions
To compare between two Lists:Step 1: Check each List
1. For cells in column B, insert the formula =IF(COUNTIF(E:E,A2)0,3,1).
2. For cells in column F, insert the formula =IF(COUNTIF(A:A,E2)0,3,2).
Step 2: Merging the Lists into one List of unique names
1. Select cell B2, and click the Sort Ascending icon on the Standard toolbar.
2. Repeat step 1 for cell F2.
3. In column E, beginning with cell E2, copy the names of those employees for whom the number 2 appears in column F, and then paste the names at the bottom of the first List.
Book Store:
Recommended Books:
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- The Analysis and Use of Financial Statements
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Positioning: The Battle for Your Mind
- Financial Statement Analysis with S&P insert card
No comments have been submitted.
