Last seen: Jun 25, 2026
@terry_tewell I corrected your file up to 6:25 into the video. Note that you had expanded the structured table to include the (dynamic array) header...
@zepold68gmail-com I'm no good with Forms or VBA but have a formula based solution, provided you are on a modern Excel version. It uses data validat...
@jtsolept It's difficult to dive into such a model without in-depth knowledge of what you looking at, but I believe there are two major issues (perh...
@navsal66 If that's really the solution you want I dare to say it can't be automated as there is no consistent logic. Only the first 6 plans have 6...
@navsal66 Once again, I don't understand the question. What do you mean by "share the link for PQ". Provided that you are on Excel 2016 or later, PQ...
@navsal66 Reading your question again, I don't understand at all. The file you attached seems to be based on what I sent you earlier. It only has 12...
@navsal66 Indeed, quite a messy pack list. Empty columns/rows, merged cells and mismatched headers as a result. But Power Query (PQ) can clean it up...
@dvodicka Do you have a question about that formula or did you just want to share a solution for a problem you faced? Replicated your situation an...
@dannyv Perhaps you'll find the articles in the link pasted below useful.
@dannyv Since you used a greater number of categories than the original template the pivot table that summarizes expenses by category becomes too b...
@navsal66 Clearly, both Anders and I have misunderstood your intentions. But I understand from your latest comment that only the last p...
@navsal66 Just to clarify. 1) The maximum number in any position on the grid is 12 2) The plan total may not exceed 120, but less is allowed ...
@katherinew Your formulas return either "1", "2", "3" or "4". The quote marks turn these values into texts whereas the conditional format looks for...
@katherinew The attached file has some basic formatting rules. See if you can apply similar rules to your own data. If not, come back here and inclu...
@navsal66 I'm not sure that I understand your question. You want to break down each of the yellow numbers into a maximum of 5 plans. And the sum of ...