Thread: How Excel can tell me i have entered a duplicate number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dav Dav is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote