» 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:
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- Writing Excel Macros with VBA, 2nd Edition
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Microsoft Office XP Introductory Concepts and Techniques
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- Good to Great: Why Some Companies Make the Leap... and Others Don't
No comments have been submitted.
