datastudent
New Member
- Joined
- Sep 7, 2021
- Messages
- 49
- Office Version
- 365
- Platform
- Windows
Hi!
I have a table where I used the filter function (column AC:AJ). Then a second table where I want the category on the first table to show and how much it cost. I would like to ask for help on how I can combine the duplicate names in my second table (column AL)?
I have a table where I used the filter function (column AC:AJ). Then a second table where I want the category on the first table to show and how much it cost. I would like to ask for help on how I can combine the duplicate names in my second table (column AL)?
| Income & Expense Tracker.xlsx | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | |||
| 1 | |||||||||||||
| 2 | MONTH | YEAR | DATE | TYPE | CATEGORY | AMOUNT | DESCRIPTION | CATEGORY | AMOUNT | ||||
| 3 | March | 2024 | 3/15/2024 | Expense | Plywood | ₱ | 3,000.00 | 0 | Plywood | 3,000.00 | |||
| 4 | March | 2024 | 3/15/2024 | Expense | Car Maintenance | ₱ | 3,000.00 | 0 | Car Maintenance | 3,000.00 | |||
| 5 | March | 2024 | 3/15/2024 | Expense | Cat Food | ₱ | 1,270.00 | dry and 3 can of wet food | Cat Food | 1,270.00 | |||
| 6 | March | 2024 | 3/22/2024 | Expense | Renew Car Register | ₱ | 3,060.00 | 0 | Renew Car Register | 3,060.00 | |||
| 7 | March | 2024 | 3/21/2024 | Expense | Gas | ₱ | 300.00 | 0 | Gas | 300.00 | |||
| 8 | March | 2024 | 3/22/2024 | Expense | Dog Grooming | ₱ | 530.00 | 30 for the diaper | Dog Grooming | 530.00 | |||
| 9 | March | 2024 | 3/24/2024 | Expense | Skin Care | ₱ | 300.00 | 0 | Skin Care | 478.00 | |||
| 10 | March | 2024 | 3/25/2024 | Expense | Ipad Loan | ₱ | 6,100.00 | 0 | Ipad Loan | 6,100.00 | |||
| 11 | March | 2024 | 3/26/2024 | Expense | Internet | ₱ | 1,500.00 | 0 | Internet | 1,500.00 | |||
| 12 | March | 2024 | 3/26/2024 | Expense | Car Loan | ₱ | 12,200.00 | 0 | Car Loan | 12,200.00 | |||
| 13 | March | 2024 | 3/26/2024 | Expense | St. Peter | ₱ | 2,300.00 | 100 for DRN | St. Peter | 2,300.00 | |||
| 14 | March | 2024 | 3/26/2024 | Expense | Skin Care | ₱ | 178.00 | 0 | Skin Care | 478.00 | |||
| 15 | - | ||||||||||||
| 16 | - | ||||||||||||
Monthly Overview | |||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| AC3:AJ14 | AC3 | =FILTER(TRANSACTIONS,(TRANSACTIONS[TYPE]=C11)*(TRANSACTIONS[MONTH]=E7)*(TRANSACTIONS[YEAR]=E8)) |
| AL3:AL16 | AL3 | =IF(AG3="","-",AG3) |
| AM3:AM16 | AM3 | =IF(AG3<>"",SUMIF($AG:$AG,AL3,$AI:$AI),"") |
| Dynamic array formulas. | ||
