Prevent duplicate entries in a column.

A

Angarsk

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hello.

I've been trying to find a way to prevent duplicate entries in a column:

I have a column for "Work order numbers" which are made of 2 letters and 5 digits (numbers). I need either to have excel stop anybody from writing the same Work order number twice in the column, or have a different column that shows something like "duplicate" if the cell is equal to other cell in the same column.

Thanks for your help.
 
J

John_McGhie_[MVP]

See here:

http://www.ozgrid.com/Excel/prevent-duplicates.htm

Cheers


Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
Hello.

I've been trying to find a way to prevent duplicate entries in a column:

I have a column for "Work order numbers" which are made of 2 letters and 5
digits (numbers). I need either to have excel stop anybody from writing the
same Work order number twice in the column, or have a different column that
shows something like "duplicate" if the cell is equal to other cell in the
same column.

Thanks for your help.

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top