#1   Report Post  
Pam Coleman
 
Posts: n/a
Default duplicate numbers

how do i set up in my database that when a user is entering infor in a
column in excel, it will tell if there is a duplicate number. I do not want
duplicates.
  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Hi Pam

See Chip's page
http://www.cpearson.com/excel/NoDupEntry.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Pam Coleman" wrote in message ...
how do i set up in my database that when a user is entering infor in a
column in excel, it will tell if there is a duplicate number. I do not want
duplicates.



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
Delete duplicate numbers Noemi Excel Discussion (Misc queries) 4 September 23rd 05 02:00 AM
how to find duplicate cells in large array of numbers wonkywombat Excel Worksheet Functions 3 August 17th 05 08:57 PM
search to identify duplicate enties in long columns of numbers Norman H Excel Discussion (Misc queries) 5 May 19th 05 07:42 PM
prevent duplicate entry for range of numbers 00001 to 99999 in ex. TK Excel Discussion (Misc queries) 4 March 6th 05 03:35 AM
How do you find duplicate values in excel- 2 columns of numbers rickmanz Excel Discussion (Misc queries) 1 December 15th 04 11:16 PM


All times are GMT +1. The time now is 08:44 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"