G Guest May 28, 2007 #1 I am using excel to record a list of data. I want it to tell me if i have duplicated an entry on the worksheet.
I am using excel to record a list of data. I want it to tell me if i have duplicated an entry on the worksheet.
G Gord Dibben May 28, 2007 #2 JoJO See Chip Pearson's site for finding and tagging/highlighting duplicates. http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates Also see the link at Chip's page bottom to "Preventing Duplicates" Gord Dibben MS Excel MVP
JoJO See Chip Pearson's site for finding and tagging/highlighting duplicates. http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates Also see the link at Chip's page bottom to "Preventing Duplicates" Gord Dibben MS Excel MVP
G Guest May 28, 2007 #4 there are several ways to find duplicates in list use folowing functions to find duplicates =COUNTIF(A:A,A2), COPY THE SAME RESULT WIL BE >1 WHERE DUPLICATES ENTERED OR USE =IF(ISERROR(VLOOKUP(A2,$A$1:A1,1,0)),"OK","DUPLICATE") AND COPY THE SAME TILL END, THIS WILL SHOW YOU RESULT DUPLICATE WHERE MULTIPLE ENTRIES FOUND
there are several ways to find duplicates in list use folowing functions to find duplicates =COUNTIF(A:A,A2), COPY THE SAME RESULT WIL BE >1 WHERE DUPLICATES ENTERED OR USE =IF(ISERROR(VLOOKUP(A2,$A$1:A1,1,0)),"OK","DUPLICATE") AND COPY THE SAME TILL END, THIS WILL SHOW YOU RESULT DUPLICATE WHERE MULTIPLE ENTRIES FOUND
