How can I compare the numbers within the transaction narrative with the credit or debit amount?

You can use one of Excel's text formatting formulas to identify whether the credit or debit matches the numbers in the transaction narrative exactly.

An example to get you started with the necessary formulas is shown here:

=IF( ISNUMBER( SEARCH( TEXT(B3,"0.00"),A3 ) ),"yes","no" )

Where, B3 contains the amount and A3 contains the narrative.

#Formula #Excel #All

Recent Posts

See All

Frequently Asked Questions, by phone

I have a warning message When does it happen? Can you send a screenshot to us? Also, if you can, please email the PDF input document to us (or upload it using the 'File' menu within StatementReader) a