» 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:
- Analyzing Markets, Products, and Marketing Plans
- Learn MS Excel 2002 VBA/XML Programming
- Microsoft Excel Version 2002 Step by Step
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Marketing Planning for Services
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...
