I want to secure a column from have the same number entered twice

J

John

I have a spreadsheet running that includes the scanning of a serial reference
number containing text and numbers on software. I need to secure that column
to prevent duplicate numbers being scanned and entered into the sreadsheet.
This then preventing dupilcate serial numbers being attached to software
before shipping. I've looked at condition formats and validation but can't
see the way forward yet.
 
J

Jacob Skaria

To prevent duplicate entries use 'Validation' from menu Data>

1. Highlight the range, lets say A1:A100
2. From menu choose Data>Validation
3. Under 'Allow' drop down choose 'Custom'
4. Enter the following formula in the Formula box
=COUNTIF(A$1:A$100,A1)=1
5. You can set a Error Alert if you need.



If this post helps click Yes
 

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

Similar Threads

How do I stop repeat entry of a number in the same Excel column 7
How do I keep from repeating a number in the same column? 3
Autonumber duplication between tables on the desktop and a PDA 2

Top