Your videos have been of great help to me, so thank you. But this one has a mix-up around timestamp 7:13. The narrator says = +I2+J2+K2, but it's actually +H3+J3+K3 like what's being typed into the spreadsheet. No?
Yes, But look at his screen... It actually says I, even though I ran on to the same problem. Just moved the H2 and H3 to the I, just as they have it. It will fix that mix up.
Hi, when attempting to copy the formula from the Receipts column (J3) into (K5) the payments column and updating the "Receipts" to "Payments" within the formula, the result i get is zero rather than the -215. The formula only works when "receipt" is within the formula and not "payment". I would say im rather good with excel however this problem has me stumped. Your assitance would be greatly appreciated.
Yes, But look at his screen... It actually says I, even though I ran on to the same problem. Just moved the H2 and H3 to the I, just as they have it. It will fix that mix up@@chimbakatongo6649
![Bank Statement download [CSV analysis in Excel] in 2021](http://i.ytimg.com/vi/tPlenecabag/mqdefault.jpg)
Your videos have been of great help to me, so thank you. But this one has a mix-up around timestamp 7:13. The narrator says = +I2+J2+K2, but it's actually +H3+J3+K3 like what's being typed into the spreadsheet. No?
Hi, Why not download the file, you can then check your work against the original. Just follow the guide set out in the video :-)
Yes, But look at his screen... It actually says I, even though I ran on to the same problem. Just moved the H2 and H3 to the I, just as they have it. It will fix that mix up.
Hi, when attempting to copy the formula from the Receipts column (J3) into (K5) the payments column and updating the "Receipts" to "Payments" within the formula, the result i get is zero rather than the -215.
The formula only works when "receipt" is within the formula and not "payment". I would say im rather good with excel however this problem has me stumped. Your assitance would be greatly appreciated.
Hi, Why not download the file, you can then check your work against the original. Downloads are available at www.MrSpreadSheet.com :-)
Hi, I had the same issue. I then Filled D7 With "Payment" and Magic! Hope it helps
Hi, did you finally get it? I'm getting 0 aswell
Yes, But look at his screen... It actually says I, even though I ran on to the same problem. Just moved the H2 and H3 to the I, just as they have it. It will fix that mix up@@chimbakatongo6649
@@raptorscrest9239 - thanks, that worked wonders!!
Would it be possible to incorporate credit cards also for reconciliation?
Yes, our 'Paid For' products incorporate 4 Bank/Card Accounts :-)