How Excel can tell me i have entered a duplicate number
 

how do i get excel to tell me i have entered a duplicate number in a specific
column

How Excel can tell me i have entered a duplicate number
 

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


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=560616

How Excel can tell me i have entered a duplicate number
 

"Autofill" wrote:
how do i get excel to tell me
i have entered a duplicate number in a specific column

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 ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---