Forum Discussion
Solved
Formula assistance
Hi everyone, I need your expertise with a formula in column F. Please see attached screenshot. So far my formula is: =IF(E2="Full CPL","Full","") I need help with the last part of the formula, th...
=IF(E2="Full CPL", "Full", TEXTJOIN("; ", TRUE, FILTER($H$1:$M$1, $H2:$M2="Brand", "")))
=IF(E2="Full CPL", "Full", TEXTJOIN("; ", TRUE, FILTER($H$1:$M$1, $H2:$M2="Brand", "")))
- That worked perfectly, thank you so much!
