Forum Discussion
Trying to use a spill range as a reference for FILTER that uses INDEX
=SORT(UNIQUE(DROP(REDUCE("",F3#,LAMBDA(u,v,VSTACK(u,FILTER(Table1[Power (kW)],Table1[Combined Values]=v,"")))),1)))
Does the formula in cell G3 return the expected result?
=SORT(UNIQUE(DROP(REDUCE("",F3#,LAMBDA(u,v,VSTACK(u,FILTER(Table1[Power (kW)],Table1[Combined Values]=v,"")))),1)))
Does the formula in cell G3 return the expected result?
Amazing! It does, thank you! While you were solving that, believe it or not I was trying to find some online resources to help me learn LAMBDA... I have zero experience with it. My workplace only moved up to 365 recently, and while there's a bunch of "new" stuff that I've got across and use regularly, there's probably more that I haven't and don't - including things like LAMBDA that I have zero concept of.
I need to test it in the actual file ASAP to see how it functions there, and importantly do a bit of study so that I can understand your solution. I'll leave my post open for the rest of the weekend to see what, if any, other approaches come though. Thanks again, Oliver 😊
EDIT / UPDATE: I copied the formula to my proper file, updated its references, and it worked exactly as required 🚀