» 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:
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.