Last seen: May 3, 2025
Difficult to help if you don't show us how your file looks like and explain the logic for splitting the file. Please attach your file.
Checked on my end. Same set-up as Alan. Everything still works for me. That is, STOCKHISTORY and Data Types.
@cal Have you considered/tried Power Query?
Can't really tell what you accidentally may have or have not done, though you can drag the sub-categories in any order you want. Then you sort them ma...
@georgeradvansky I would add the Year and Month in both the Budget and Transactions tables before appending them into the Data table. See attached. ...
I couldn't really follow your approach and can't answer the question. But I understand what you are trying to achieve and suggest you simplify the for...
@georgeradvansky Hi Jiri, I would really need to have a look at your file again, otherwise I can not see what you have done.
@rennae Well, how did the transaction get in there? Let's have a look at January for Loan. There is an entry on 13 Jan for 113.34 and another on 2...
I've looked at the transactions data and conclude that the total spending of living expenses is indeed $20,596 as included in the report section. "Cat...
Yes, now I see the table. Thanks. First of all, why does it have the csv extension when it is not a csv file? After ignoring a warning message, Exce...
@georgeradvansky I don't see the file. Can you try again?
Difficult to help without looking at your file. Could you upload it? Just remove any private and confidential information.
Glad you worked it out either way!
I notice that you have applied conditional formatting to color negative variances red and white for cells that equal zero. The latter you don't really...
See if the attached solution tackles your problem. Not sure I fully understand your case though. I added a calculated column that functions like a ...