Last seen: May 18, 2025
@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...
@j8150outlook-com not sure that I fully understand, though that template merely displays 8 weeks at the time. You probably can't see more on a mid-s...
@navsal66 Try this one: =SUMPRODUCT(--ISNUMBER(FIND(E4,$B$4:$B$11))*$C$4:$C$11)
@navsal66 I believe this does what you need. =FILTER($C$4:$C$11,ISNUMBER(FIND(E4,$B$4:$B$11)),"-")