top of page

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

  • Writer: David
    David
  • Oct 13, 2016
  • 1 min read

Updated: Nov 14, 2019


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.

Recent Posts

See All

Comments


Message us or

Call us on +44 (0)20 3287 8283

Mon to Fri: 8am-8pm

Weekends: 10am-6pm

bottom of page