Last seen: Jun 14, 2025
@ukdj Structured tables don’t allow dynamic array functions that spill results into multiple cells. It defies the whole nature and purpose of struct...
@patrick-leibovichgmail-com I believe it was the attached one.
@carthyeilygmail-com Great! After I posted my previous answer, I thought that you can actually achieve a very similar result without the need for P...
@carthyeilygmail-com Thought very hard about it and couldn't figure out a manner to achieve what I believe you want in the way you described. But t...
@carthyeilygmail-com Could you upload the data table as you had it in your original post. And the sales table that 'belongs' that that data? I.e....
@bee Perhaps best to demonstrate in a working model. Does the attached file contain the solution you need? If not, what would be the end result you...
@jessica5 Ah, I see. That combination makes it difficult indeed. The only solution I can offer is by creating the bar chart from a structured data ...
@jessica5 Sort the pivot table in ascending order by sport first, then by value in ascending order. A bar chart will then display in descending valu...
@bee Not entirely sure on how you built your schedule as your data doesn't seem to be in a structured table. I would recommend you do that. Regard...
@carthyeilygmail-com I've added the Excel formulas to your file so that I could compare the PQ outcome. The query is quite basic though requires som...
When you mention the need to deal with "huge datasets" I suggest you look into learning Power Query (link below).
It's your measure for the % change that messes things up but I can't articulate why. All items with no sales values return -100% based on the "-1" at ...
@orianfnlc-org-au Ah, I see. The problem was that you used relative references in XLOOKUP. The first formula looked at rows 1:25. Dragged down, the...
@orianfnlc-org-au Yes please, upload the file. Just remove anything confidential.
@orianfnlc-org-au Not sure what you mean. Ctrl-Shift-Arrow down just selects cells from the active cell up to and including the first non blank cell...