compair
 

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?

compair
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"bbrodsky" wrote:

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?