ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Here's a good challenge for someone to work on (https://www.excelbanter.com/excel-programming/281767-heres-good-challenge-someone-work.html)

The Foreman

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???????????????????????????

Arvi Laanemets

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???????????????????????????




All times are GMT +1. The time now is 07:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com