Thread
:
Find duplicates w/3 criteria
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Claus Busch
external usenet poster
Posts: 3,872
Find duplicates w/3 criteria
Hi,
Am Mon, 11 May 2015 09:10:03 -0700 (PDT) schrieb
:
I would like in column D a Y or N to indicate the cells in that row are duplicates because they show up elsewhere in that column.
ROW Col A ColB ColC ColD
Dt Tmstamp Item ID Work Order Result
1 5/7/2015 14:20 142532 775502 N
2 5/7/2015 14:24 142416 775502 N
3 5/7/2015 14:25 142416 775502 Y
4 5/7/2015 14:25 142416 775502 Y
5 5/7/2015 14:25 142416 775502 Y
6 5/7/2015 14:48 171071 N
in D2 try:
=IF(MATCH(B2&C2,B$1:B$100&C$1:C$100,0)=ROW(),"N"," Y")
ans enter the array formula with CTRL+Shift+Enter and copy down
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch