» Comparing Lists Using the COUNTIF Formula
CATEGORY - Counting
VERSION - All Microsoft Excel Versions
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:
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- The One Page Business Plan: Start With a Vision, Build a Company!
- The 22 Immutable Laws of Branding
- Excel 2002 Power Programming with VBA
- Keys to Reading an Annual Report (Barron's Business Keys)
Really Excellent Tip !!
Syed Muti-ur-Rahman
If someone understands and tries this tip, it saves a lot of time comparing two lists with similar data.
Thanks to Exceltip.com.
Typo on the Formula
ah
The formulas posted are missing the > before the 0,3,1) -- I was having trouble getting it to work until I referenced the screenshot and saw the correct formula syntax.
Thanks to Exceltip.com.