Tigerexcel
Active Member
- Joined
- Mar 6, 2020
- Messages
- 493
- Office Version
- 365
- 2019
- Platform
- Windows
Classifying expenses.xlsx | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | Amount | Details | Transfer out | Transfer in | Rent | Tax | Rates | Water | ||
2 | -$1,500 | Transfer to other Bank | Transfer out | |||||||
3 | $1,000 | Transfer from Bank | Transfer in | |||||||
4 | $12,000 | Water City | Water City | |||||||
5 | $500 | Rent Suburb | Rent Suburb | |||||||
6 | $3,000 | Rent City | Rent City | |||||||
7 | $6,000 | Rates City | Rates City | |||||||
8 | $3,000 | Rates invoice City | Rates City | |||||||
9 | $500 | Tax invoice Suburb | Tax Suburb | |||||||
10 | ||||||||||
11 | ||||||||||
12 | Summary | Balance | ||||||||
13 | Transfer out | $1,500 | ||||||||
14 | Transfer in | $1,000 | ||||||||
15 | Rent Suburb | $500 | ||||||||
16 | Rent City | $3,000 | ||||||||
17 | Rates City | $9,000 | ||||||||
18 | Water City | $12,000 | ||||||||
Sheet1 |
Desired output is in C2 to H9. Ultimately would like to have a summary as shown. The problem I'm running into is that the Detail field can vary but I'd need formulae/functions to pick up variations such as Rates City or Rates Invoice City. The details do come in an inconsistent manner so could also have something like Invoice 234 Rates (Jan to Mar) City.
Last edited: