Sub M_snb() [c2:C200] = [if(B2:B200="","",if(B2:B200=0,"",B2:B200 & " units of " & A2:A200))] [K1] = Join(Filter([transpose(if(B2:B200="","",if(B2:B200=0,"",B2:B200 & " units of " & A2:A200)))], " "), " / ") End Sub
Sub M_snb() [c2:C200] = [if(B2:B200="","",if(B2:B200=0,"",B2:B200 & " units of " & A2:A200))] [K1] = Join(Filter([transpose(if(B2:B200="","",if(B2:B200=0,"",B2:B200 & " units of " & A2:A200)))], " "), " / ") End Sub