Forum Discussion
Solved
Formula not working anymore
I've been copying and pasting this formula for a while. Since today it seems like its not working =TEXTJOIN(", ",TRUE,FILTER($B$29:$B$59,ISNUMBER(SEARCH(", "&B61&", ",", "&$R$29:$R$59&", ")),"")) ...
Did you change the decimal separator from point to comma? If so, the formula should be
=TEXTJOIN(", ";TRUE;FILTER($B$29:$B$59;ISNUMBER(SEARCH(", "&B61&", ";", "&$R$29:$R$59&", "));""))
Did you change the decimal separator from point to comma? If so, the formula should be
=TEXTJOIN(", ";TRUE;FILTER($B$29:$B$59;ISNUMBER(SEARCH(", "&B61&", ";", "&$R$29:$R$59&", "));""))
- this works... i still dont understand why since i went to a previous comment i made with this formula (which you answered thanks you very much). not sure what changed but thanks for the quick answer.
ref:
https://techcommunity.microsoft.com/t5/excel/excel-windows-and-mac/m-p/3725141#M178387
