Hello, I have a bunch of categories and i am trying to condense the view Monthly budget tab. The formatting is setup to show the groups and then the categories under the group and then skip a row before showing the next set. I am essentially trying to update the formulas so that it does not skip that row in between. I tried to adjust the formulas off to the right but they are interdependent and i am not advanced enough. Can someone help with this?
I understand what you are trying to do, but be aware that these formulas a pretty fussy— though you can always undo any changes or restore the template. The formulas you need to change are in N16:P16. The ones in O and P are array formulas. The ones in N will need to be expanded to the bottom of the sheet.
If you get it working, share your result….
1 Like
i set up a macro to hide the rows temporarily but the macro runs quite slow. It is a simple one so i am surprised it goes so slow but i will keep working at the formulas to see if i can get it. thanks
That’s creative. You can see that columns L:M:N identify the index of the types, groups and categories, and then then fussing with the offsets in O16 & P16 will get you what you want.
Oh… just seeing now you’re working in Excel. It’s the same idea but the cell locations might be a little different.
got what i need adjusting the macro to hide rows based on the values. These buttons i added at the top allow me to view quickly at a high level (groups) or full broken out with all my categories. Hitting the Detail button gives me this view.
and hitting the Summary button gives me this one.
Thanks for sharing the outcome! 