View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kanamohyd kanamohyd is offline
external usenet poster
 
Posts: 1
Default matching Check # for Bank Reconciliation through Excel

I want to do Bank Reconciliation through Excel. Is there any function or
formula that can help me in matching the check number given in a column of
Data A of Sheet 1 with check number given in a column of Data B of Sheet 2
within the same workbook.

Alternatively, is there any function or formula that can identify the mis
matched check numbers given in the data on two separate worksheets of the
same work book.

I am using Excel 2003.