I am trying to manipulate the results of a TEXTSPLIT I have done.
Formula for reference:

=INDEX(TEXTSPLIT($W16,{"[","]"},{",","WorkCenter[ActualQty]:"},TRUE),,)

After splitting the text, my results are as follows:
Split Between Operation and Quantity good

I am using a SWITCH function to change the operations to have specific letters(referenced below):

=SWITCH(INDEX(TEXTSPLIT($W16,{"[","]"},{",","WorkCenter[ActualQty]:"},TRUE),,1),"M400CLEAN","C/","PICKLE","C/","11X3COAT","C","10X2COAT","C","11X1COAT","","DRAW4SHAVE","D","WIREDRAW","D","SHAVE","SH","C/C","C/C","BOXANNEAL","A","PITANNEAL","PA","TANK24","M","COPPER","CU","FINDRAW","DF","SCRAP","","ENGINSP","","PULLMAT","PULL - ","STRIP4SHAV","","STRIP","","FINALINSP","","SHIPAPPR","","IGAINSP","","BLOCK3","D","LABINSP","","S/C&G","S/C&G")

Results of the formula adjacent to the first one.

All of this works perfectly, but I want to eliminate the letters from popping up if they are associated to a missed transaction (Entered weight is 0, and the next operation has a weight >0).

Additionally, I do not want the cell to spill over as it is doing. So doing a direct cell reference to the spill over cell would not be possible.

For this example, “C/C”,”PICKLE”, and “WIREDRAW” are all missed transactions that have a letter pop up, that should not.

Please help me or reference an article/video that can.

Thank you all!