» Find duplicates items in combine columns in Microsoft Excel
CATEGORY - Other Q&A Formulas
VERSION - All Microsoft Excel Versions
-------------------------------------------- Dates in column A Text in Column B -------------------------------------------- 03/10/2003 | AAA 03/15/2003 | BBB 03/20/2003 | CCC 03/25/2003 | AAA 03/30/2003 | BBB 04/04/2003 | CCC 03/25/2003 | AAA 03/30/2003 | BBB 04/04/2003 | CCC 03/25/2003 | AAA 03/30/2003 | BBB 04/04/2003 | CCC Enter the formula : =A1&B1 to cell C1 and copy / paste the formula to cells C2:C12 Enter the formula : =IF(COUNTIF($C$1:C1,C1)>1,"Duplicate","Unique") to cell E1 and copy / paste the formula to cells E2:E12
Book Store:
Recommended Books:
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Special Edition Using Microsoft Word 2002
- Retire Young, Retire Rich
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Marketing Management
Finding Duplicates in combined Columns
AlbertWells
A great concept that works well! You will need to copy and paste values only in the E column, however to sort the dublicates lists for deletion...
