compair

  • Thread starter Thread starter bbrodsky
  • Start date Start date
B

bbrodsky

We issue about 1500 to 2000 checks every month. I can place the list of
check numbers and amounts from our payroll software on an excel spreadsheet
and I can take the list from our bank and place it on the same spreadsheet.
What I need to know is how can I compare the two lists to see what checks
have not cleared the bank?
 
Let's say numbers are in column A, bank list is in column B (starting on row
2). In C2:

=IF(ISNA(MATCH(A2,B:B,0)),"Not cleared","Cleared")

Copy down as needed. You can then use AutoFilter on this column to quickly
see what you have outstanding.
 
Back
Top