Hi,
I have two departments. Operations and Finance.
Operations sends an completed project for invoicing and log it in a column on a sheet only used by Operations
Finance receives the invoice and process the invoice to get paid, but I have hundreds of clients thus every client pays the invoices on different times.
My issue is over 15 years a lot of information has been captured.
I'm looking for a formula that can compare my operations invoices send (Column 1) with Finances paid invoices (Column 2) and return all invoices not paid in Column 3
The other formula I want is to compare Column 1 and Column 2 and return all invoices that is not found in column 2 but is in column 1. i.e. look for duplicate invoices/find matching invoices between two column but return only invoices that is not duplicated in 2 columns
I have two departments. Operations and Finance.
Operations sends an completed project for invoicing and log it in a column on a sheet only used by Operations
Finance receives the invoice and process the invoice to get paid, but I have hundreds of clients thus every client pays the invoices on different times.
My issue is over 15 years a lot of information has been captured.
I'm looking for a formula that can compare my operations invoices send (Column 1) with Finances paid invoices (Column 2) and return all invoices not paid in Column 3
The other formula I want is to compare Column 1 and Column 2 and return all invoices that is not found in column 2 but is in column 1. i.e. look for duplicate invoices/find matching invoices between two column but return only invoices that is not duplicated in 2 columns