d2jsp
Log InRegister
d2jsp Forums > Off-Topic > Computers & IT > Programming & Development > Looking For Excel Formula Help
Add Reply New Topic New Poll
Member
Posts: 61,373
Joined: Mar 14 2006
Gold: 10.77
Apr 6 2022 04:56pm
I wrote this to simplify a process at my job, but I want it to remove all instances of the word English from the textjoin. I’ve tried a few things but keep returning errors. Anyone know how to get a text join to just “” certain words?

="Language: "&TEXTJOIN(", ",TRUE,SORT(UNIQUE(An2:An500))))
Member
Posts: 61
Joined: Mar 31 2006
Gold: 170.60
Apr 7 2022 11:32pm
Try this... the conditional statement did the trick for me.
="Language: "&TEXTJOIN(", ",TRUE,SORT(UNIQUE(IF(An2:An500<>"English",An2:An500,""))))
Member
Posts: 613
Joined: Oct 29 2021
Gold: 826.00
May 29 2022 04:27pm
I would do it with a macro instead of just a formula.
Go Back To Programming & Development Topic List
Add Reply New Topic New Poll