HOW DO I GET A WARNING FOR REPEATED NUMBERS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a spreasheet in excel I have got invoice numbers but i need
to create a warning for repeated invoice numbers.Any help would be most
appreciated.
Thanks
 
For those who are not as computer literate. Here follows instructions:Click
on A to high light that column. Go to Data. Go to validation.In settings go
to Allow and put in Custom.In formula put the formula =COUNTIF(A:A,A1)=1.
Follow this procedure with column B or C ect and substitute A for B or C ect
in formula box.
 
You must log in or register to reply here.

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 get a warning for repeated numbers 1
Outlook Creating an Outlook form 2
excel macro 1
template creates invoice - how to create summary worksheet? 13
Auto Number 1
Repeat headers only when data existss 1
EXCEL to update a number each time worksheet opens. 2
How do I set up an automatic invoice number in Excel 2007 1

Back
Top