• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

invoice number

Z

zoukou55

New Member
Hi


I have a file to register all my invoices. I don't want to put twice the same invoice number


Is it a formula or way that Excel can tell me that the invoice number already exists


thanks
 
You could probably find other solutions fairly quick, but I'd suggest starting here:

http://blogs.office.com/b/microsoft-excel/archive/2012/01/12/generate-invoice-numbers-in-excel.aspx
 
Hi,


From what I understand, you are entering the invoice numbers in a sheet and want to be alerted if a number already exists in the sheet.


Try conditional formatting with new rule and formula.


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


Format as required.


Jai
 
Digging through the archives, looks like Chandoo himself covered this topic once. Might have some good ideas/templates

http://chandoo.org/wp/2009/07/20/invoice-numbers/
 
I am happy with Jai answer with the count if

but I just one to put 2 count if

the first one to check the invoice number and the second one the supplier name


For example: If I tape invoice 1 twice excel will tell me with the count if function this is duplicate but something, we have 2 different suppliers with the same invoice number

so If invoice 1 has already been taped for supplier A, excel will tell me: this is a duplicate
 
Hi,


Try,


=COUNTIFS($A$1:$A1,A1,$B$1:$B1,B1)>1


as the conditional formatting rule.


Jai
 
You must log in or register to reply here.
Back
Top