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&", ")),""))
I've been to older workbook where i know this formula worked. and it seems like now it does not work anywhere.... I am baffled. i get the error message below.
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
