View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Donna[_2_] Donna[_2_] is offline
external usenet poster
 
Posts: 76
Default Pulling out invoices that do not match

Hi,
I have 2 columns , Col A has invoice numbers and Col B has invoice numbers.
All of the invoices will be included in Col A but all will not be included
in Col B. I want to be able to pull out the invoices in Col A that did not
have a corresponding Invoice number in Col B.
Col A Col B
123456 123456
155456 113984
113984
Any help will be appreciated.