Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Here's a good challenge for someone to work on

When typing new entries on a list is there a way to auto goto so you do not have multiple entries???????????????????????????
  #2   Report Post  
Posted to microsoft.public.excel.programming
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???????????????????????????


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
And in case I don't see you,good afternoon,good evening,and good n msnyc07 Excel Discussion (Misc queries) 1 June 1st 10 11:24 AM
vlookup and hlookup formula, a good challenge Frances C[_2_] Excel Worksheet Functions 5 September 29th 07 05:56 PM
Biff or anyone- A further challenge for work schedule creation Paul Excel Discussion (Misc queries) 13 January 15th 06 05:11 PM
The Good Ole Work Schedule... birdwig Charts and Charting in Excel 0 November 30th 05 04:28 AM
How do I make this formula work =if(a1=(b10:b20),"good","bad"). AK Excel Worksheet Functions 2 December 2nd 04 01:13 AM


All times are GMT +1. The time now is 02:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"