Forum Discussion
I can't find a formula to spill range with multiple conditions. URGENT !!!
Nishkarsh31 Perhaps like in the attached file? Not very elegant, but it seems to work.
I think the problem has moved on since looked at it this morning (then moved to a phone that had been turned to junk by an overnight iOS update). It is not always possible to return results as a spilt range, much as I would like it to be so. In this case, I think it is possible, since the ...IFS() family of functions split the criteria range from the criterion values (a scalar or lifting to an array).
In general terms, the way of recovering arrays from formulas and functions that work row by row is to use the LAMBDA function and recursive formulae, but that is still work in progress.
Yes, we've figured out a way to do this using sumproduct. We now are stuck at a filter argument, to filter the descriptions which aren't matched. I'm attaching the new file. Please give it a look. I've exhausted my brain over this.
One solution as suggested by Riny_van_Eekelen sir, is to split the description columns into separate columns using a formula. If that's our only way out. I'm on board, I just wanna get it done now.
In that case though, I checked some of the data entries would have 5, some 4 separate columns. How do we tackle that?
PeterBartholomew1