Thread: check for previous entry
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
  
Posts: 9,221
Default check for previous entry
You could apply data validation on that col D

Select col D
Click Data Validation
Allow: Custom
Formula: =COUNTIF(D:D,D1)<2
Click OK

Test it out ..
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"MichaelCasper" wrote:
I use column "D" for entering invoice numbers.How can I have Excel lock at
all previous enteries to see if I am duplicating an entry on any other row of
column "D"
Reply With QuoteReply With Quote