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).
- P11d query 268 5
- Rental expenses 52 1
- Intercompany Payroll Journals 132 5
- What are my legal responsibilities 345 14
- Business lending another business money (UK) 85 2
- Rental business through company without owning the property? 336 4
- No more tax returns... 1,540 13
- How much state pension will client lose out if drops salary 420 6
- Signed accounts for bank 285 7
- Companies House paper incorporation - date of birth omission 476 10
- Landing clients 420 15
- Are any of you members of The Institute of Financial Accountants - Accountnats certificate 1,153 22
- Termination Payment 206 5
- dividend date - whose income is it? 213 3
- CRM / marketing 109 2
- Allocation of income from property 757 26
- Stand alone practice management software 1,885 28
- Opening a Quick books file 138 1
- 64-8 problems 522 8
- Guaranteed rents - which is the turnover? 350 10