7 January 2013

First client

31 December 2019

Last software update

< 2 hours

Support response

StatementReader is used by forensic accountants, bookkeepers, insolvency investigators, solicitors, auditors and business review professionals to stop wasting time and talent converting bank statements into Excel

This website uses cookies to enhance the user experience.  Click here for our cookie statement and here for our privacy policy.

All Rights Reserved 2012-2020 Suave Software Limited. London, England, United Kingdom. Email Us

  • LinkedIn Social Icon
  • Twitter Social Icon

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