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...
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
I have 6 items in my drop list and with their own budget
When I chose an item, it is possible that his budget appears in the appropriate cell
for example, when I chose "vehicle maitenance", I want to see automatically his budget, his cost centre, and total cost
thanks