| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Change number when you open the excel template | Excel Discussion (Misc queries) | |||
| Access Excel Linked Text and Number Issues | Excel Discussion (Misc queries) | |||
| Excel not taking number format consistently | Excel Discussion (Misc queries) | |||
| Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Linear Mode
