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) )
Patrick2788 Hi Patrick, thanks a lot for your help so far. I am finding that when column F does not equal Full CPL I am receiving a #CALC! error. Any suggestions? Thank you.
It could be an issue with the way "true" is listed in your sheet. Is it text "true" or a logical TRUE.
- 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?
- 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!