Forum Discussion
Solved
Help with Excel formula
Hi everyone, I have a formula in P2 that looks to see what is in F2. If F2 says "Full CPL", then put "Full" in P2. If it does not, then take the column header names from columns H through N and sepa...
Try this one:
=LET( swap, SWITCH(size, "2XL", "3XL", size), filtered, UNIQUE(FILTER(swap, E2:J2 = "true"), 1), TEXTJOIN(", ", 1, filtered) )
Hi Patrick, they are all text "true".
The #CALC! error suggests FILTER is failing. Is H2:N2 the range in your sheet where "true" may be found?
- Glad it is working!
- I see what you mean. I had used "true" in my fake spreadsheet but in my real spreadsheet it is a different value. Once I changed what is in the quotes the formula worked beautifully. Thank you so much Patrick!