Excel - 'find me the numbers that add up to this'?
This happens to me more often than you'd think, so a shortcut would be a help!
A client (or sometimes a colleague) will present a column of numbers on Excel and note that they have claimed £x from it, but make no mention of which numbers have been used.
Case in point, a client gives me a list of 50+ items all neatly laid out. They tell me '£2,895 of these expenses I think are private'. Great, but which ones are they?!? Can Excel somehow find me the cells that would add up to that total? Or am I asking too much :)
Otherwise it is a bit of trial and error (that £3,000 expense clearly doesn't feature, but a lot of them are well under £2,895).
- Rounding errors on CT600 75 3
- Entrepreneurs' Relief upon sale of a cash rich company 2,278 48
- BrightPay quirks 147 2
- Leaving the VAT FRS Scheme or trying to stay as long as possible? 64 1
- HMRC now overriding SA bank repayment details on tax returns 780 20
- Xerocon 2016 1,157 31
- Website Content 57 1
- Mortgage Reference 464 5
- Personal Tax 609 12
- New Build 137 1
- Claiming annual pension allowance top up in SATR 106 1
- Starting band for savings - for 2014/2015 139 1
- USA Tax Query 274 2
- Website costs (intangible assets) tax relief 422 5
- last minute request 628 6
- buying asset and settling vendor's debt 328 6
- Posting invoices with balance brought forward 361 7
- Disengagement Help! 1,720 25
- Is HMRC Basic Tools basically wrong? 983 6
- Expenses paid by director (the comapny owner) 398 2