CODEWITHSUNDEEP
if-statementgoogle-sheetsgoogle-sheets-formulaarray-formulascode-splitting
Qlowls
Qlowls

Reputation: 1

spliting based on a condition and Array arguments to IF are of different size

I'm working on a sheet that can be extracted from a system and all the data is in one cell so i need to split them and it is basic for all cells except for resutls. as you can see test results should follow the same pattren of result status. so i regularlly splited one column (test status) and i tried to split test results based on if condition

it worked perfectly, however, for some status test results were not spliting because (Array arguments to IF are of different size.)

how do i fix this, please help

Thank you

Upvotes: 0

Views: 68

Answers (2)

rockinfreakshow
rockinfreakshow

Reputation: 30097

You may try this:

=BYCOL(C2:G2,LAMBDA(Σ,(IF(Σ<>"Final",,INDEX(SPLIT(H2,","),, COUNTIF(C2:Σ,Σ))))))

enter image description here

Upvotes: 0

Harun24hr
Harun24hr

Reputation: 36965

Because IF() function is checking only first cell of C2:G2 range. Concat them into a single string them use search function to detect word Final. Try-

=IF(ISNUMBER(SEARCH("Final",JOIN(",",C2:G2))),SPLIT(H2,","),"")

Upvotes: 1

Related Questions