Exclude Dupllicate

  • Thread starter Thread starter JJ
  • Start date Start date
J

JJ

Can anyone tell me if it is possible to format a colomn of cell to prevent
duplicate information from being entered. For example, I do not want to
enter the same invoice number twice.

Thanks
 
JJ,

Set up a data validation range. Select the range a1:a10. In the validation
settings set "Allow" equal to "Custom", type in this fomula:

=countif($A$1:$A$10,A1)=1

Don Pistulka
 

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

Text Output To CSV 5
Sum with condition 3
Faststone Image viewer popups! 2
Sort duplicate fields 5
How do I prevent duplication information, such as SSNs in cells. 1
Merging Information 1
Conditional formatting 9
deleting duplicates 2

Back
Top