G Guest Jul 12, 2006 #1 how do i get excel to tell me i have entered a duplicate number in a specific column
D Dav Jul 12, 2006 #2 Well one way is to go to conditional formating and choose formula and in cell A1 put =countif(a:A,a1)>1 and format to turn the cells red this will highlight duplicates in red Regards Dav
Well one way is to go to conditional formating and choose formula and in cell A1 put =countif(a:A,a1)>1 and format to turn the cells red this will highlight duplicates in red Regards Dav
G Guest Jul 12, 2006 #3 Autofill said: how do i get excel to tell me i have entered a duplicate number in a specific column Click to expand... Another play is to use Data Validation Select col A Click Data > Validation Allow: Custom Formula: =COUNTIF(A:A,A1)<2 Click OK Test it out .. ---
Autofill said: how do i get excel to tell me i have entered a duplicate number in a specific column Click to expand... Another play is to use Data Validation Select col A Click Data > Validation Allow: Custom Formula: =COUNTIF(A:A,A1)<2 Click OK Test it out .. ---
