Forum Discussion
Solved
Concatenate IF help
Hi everyone, I have been trying to use concatenate with the IF function to generate product allergens by ignoring the word none. I basically have: Column K has the below Allergen Informat...
Aaargh, it's not my day. Wrong order of the functions.
=TEXTJOIN(", ",TRUE,UNIQUE(FILTER(K23:K35,K23:K35<>"None","None")))
Apologies, which reply are you referring to? I tried the UNIQUE function you mentioned above which as I said on my reply just above worked fine for the "none" issue but it still gives duplicate allergens.
Aaargh, it's not my day. Wrong order of the functions.
=TEXTJOIN(", ",TRUE,UNIQUE(FILTER(K23:K35,K23:K35<>"None","None")))
- Hahaha it's ok, IT WORKED!! honestly thanks so so much for the help, wish I could understand functions as well as you do! Hope you have a lovely day x