View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
 
Posts: 510
Default Here's a good challenge for someone to work on

Hi

P.e. for column A
Select the column
Data.Validation.Custom
Formula=COUNTIF(A:A,A1)<2
OK


--
(When sending e-mail, use address )
Arvi Laanemets


"The Foreman" wrote in message
news:aZEqb.96443$275.268226@attbi_s53...
When typing new entries on a list is there a way to auto goto so you do

not have multiple entries???????????????????????????