Finding numbers which are in 2 columns, not just one

**marknorton** · 03-31-2007, 07:35 AM

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

**VBA Noob** · 03-31-2007, 07:40 AM

This link may help

http://www.cpearson.com/excel/duplic...tingDuplicates

VBA Noob

**mikerickson** · 03-31-2007, 03:17 PM

You could use conditional formatting with the custom formula

=(2>COUNTIF($a:$b,a1)) , if you are sure that there are no dupicates in either column.

Lacking that surity, you could use
=(1>COUNTIF($b:$b,a1)) to conditionaly format column A and
=(1>COUNTIF($a:$a,b1)) for column B.

Finding numbers which are in 2 columns, not just one

LinkBack

Thread Tools

Rate This Thread

Display

Finding numbers which are in 2 columns, not just one

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions