Clearwater Tim

Posts: n/a

How do I prevent duplicate numbers from being entered in a column.

I am trying to set a check register example and want to prevent the user from
entering the same check number twice. Is this possible in Excel?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Data validation to prevent duplicate entry.	vishu	Excel Discussion (Misc queries)	0	March 14th 05 11:33 AM
prevent duplicate entry for range of numbers 00001 to 99999 in ex.	TK	Excel Discussion (Misc queries)	4	March 6th 05 03:35 AM
Prevent duplicate entries	Teri	Excel Worksheet Functions	1	March 4th 05 01:28 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
Add numbers for duplicate entries then delete	Chillygoose	Excel Worksheet Functions	1	November 2nd 04 04:35 PM

All times are GMT +1. The time now is 01:33 PM.

About Us

"It's about Microsoft Excel"