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...
top of page
Knowledge base
Search
1 min read
How can I strip out the recipient from the transaction narrative?
Some text manipulation can be used to cut out the sections of the narrative that interest you. This formula looks for 'from' or 'to' and...
1 min read
Is there a quick way to write a lengthy IF statement?
When Excel reads a statement that returns TRUE or FALSE, these values are interpreted by the formula as 1 or 0, respectively. Therefore,...
1 min read
What are absolute and relative formulae?
When you copy and paste formulae that reference other cells within a spreadsheet, the cell references are automatically interpreted as...
1 min read
How can I search Companies House data for many companies?
If you have a list of many company names (perhaps creditors or debtors) and you need to check which ones are dissolved or subject to...
1 min read
Balance checks using SUM
Balance checks are used to validate that the data exported from bank statements is correct. They are quick and easy to apply, although...
1 min read
Single condition summary using SUMIF
SUMIF can be used to summarise many transactions for a single condition. Here are some examples: - Show the total credits where the date...
1 min read
Multi-condition summary using SUMPRODUCT
SUMPRODUCT is a powerful formula that can be used to summarise transactions that satisfy many different conditions. Here are some...
1 min read
Date adjustments using DATE
Changing dates across many lines of transactions can be tiresome. To ensure that this process is fast and accurate, you should use the...
bottom of page