Find duplicates items in combine columns in Microsoft Excel

» Find duplicates items in combine columns in Microsoft Excel

VERSIONS: 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

Screenshot // Find duplicates items in combine columns in Microsoft Excel

Rate this tip



1	2	3	4	5

RATING: 3.81
VIEWS: 189752

Email Tip

Print Tip

Add to My Tips

Finding Duplicates in combined Columns

AlbertWells wrote on December 31, 1969 19:00 EST

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

Sponsors:

Book Store:

VIEW ALL BOOKS

Recommended Books:

Related MS EXCEL TIPS:

Terms and Conditions of use
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.