CATCHING DUPLICATE INFORMATION IN DIFFERENT CELLS SAME PROGRAM

**lisa** · July 20th, 2006, 12:12 PM posted to microsoft.public.excel.setup

I am working in excel and need to have a warning when information previously
keyed is being duplicated in the same colums. Example: column B is always
ticket numbers. I want excel to warn me if while keying in column B I key
the same number in a different cell. I want this restricted to certain
columns not the entire workbook.

**Gord Dibben** · July 20th, 2006, 05:21 PM posted to microsoft.public.excel.setup

Lisa

Check out Chip Pearson's site for "preventing duplicates".

http://www.cpearson.com/excel/NoDupEntry.htm

Gord Dibben MS Excel MVP

On Thu, 20 Jul 2006 04:12:01 -0700, Lisa wrote:

I am working in excel and need to have a warning when information previously
keyed is being duplicated in the same colums. Example: column B is always
ticket numbers. I want excel to warn me if while keying in column B I key
the same number in a different cell. I want this restricted to certain
columns not the entire workbook.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I delete duplicate cells?	AYANG	Worksheet Functions	1	June 27th, 2006 06:29 AM
converting a string of information into excel cells	H.W.	Worksheet Functions	5	April 18th, 2006 07:01 PM
duplicate information	Alana	Database Design	6	November 7th, 2005 10:34 PM
Preventing Duplicate Cells	BenBlair	General Discussion	2	May 19th, 2005 06:08 PM
How do I get all my Word documents within one Word window	RobJacobs	General Discussion	2	April 12th, 2005 03:04 AM