how can i stop the same thing being repeated in a column?

T

the_osiris

I have a list of contract numbers at the end of each contract number (whoch
is 6 digits long) I have an a1 or a2 or a3...etc. The a stands for
application and the number represents the application number.
I want to format the cells so that no application number is entered in twice.
ie. if for example 022078a2 had already been entered. But someone tries to
re-enter it again an error message will appear.
I have already have an error message appearing if the someone enters data in
to that colunm that doesnt match the following format 'nnnnnnan'
 

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 can i stop same data being repeated in a column 3
How can i stop data being repeated within a column? 2
Check a 'Logsheet' for a match, before continuing a sub 4
Finding Minimum but if same number repeats in the range, then find 1
How do I keep from repeating a number in the same column? 3
How do I stop repeat entry of a number in the same Excel column 7
How can I display symbols in phone # formatted cell when empty? 1
How do I stop Excel from copying date format from cell above? 2

Top