Last seen: Jun 25, 2026
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)),"-")
@knutjdahl I'm afraid that the structure of your table isn't suited for what you want, other than what you described. The attached file contains a s...
@orianfnlc-org-au The list source must indeed be a reference to a single row/column or a delimited list that you may type into the list box, For ex...
@kna Your question in English: "Hello Sir, given the simplicity with which you solved my problem can you give me the algorithmic logic that you f...
@orianfnlc-org-au You should NOT enter "F3" in the source box but click inside the box and press the F3 (function key). That brings up the Paste Nam...
@kna Sure. what is does is concatenate the values from three cells using the &-sign and TEXT function to format numbers in a particular way. T...
@knAPS Perhaps like in column T in the attached file??
@kna OK, then that is indeed the formula you had in your file. According to my "translator" your last message reads as follows: "In fact it is du...