1 minHow 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...
1 minHow 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 minIs 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 minWhat is a CSV file?CSV (Comma Separated Values) is a file format that is widely accepted when importing data into a variety of different applications. It...