Hi

Me again! I now have another problem. I'm creating a sheet to make sure all my invoices have a payment linked to them. They're linked by the invoice number.

In column A I have a list of Invoice numbers from my sales. In column B I have a list of Invoice numbers from my bank receipts.

Is there a formula to highlight any invoice numbers which don't feature in both columns? This would give me a list of which invoices have a sale created for them, but we haven't received payments?

Any help would be great!

Cheers
Mark