SOLVED

TextJoin function is not working - Looking for prompt solution

Copper Contributor

In the attached excel TextJoin function returns no value in the yellow marked cells where in the same formula returns value in the blue marked cells.

I am not able to figure it out... pls help to sort out this issue.

Thank you.

5 Replies

@Safy84 

F39 an G39 don't contain a 1 but 0,999999999999999.

 

Thank u for figuring out the problem area. But unfortunately,F39 & G39 returns the value from F42 to F66 & G42 to G66 which is the rank formula, so getting decimal is not possible there. Can you pls help to sort this further too.

@Safy84 

You may round result in this formula

=TEXTJOIN(",",TRUE,IF(1=ROUND(F$38:F$59,5),$A$38:$A$59,""))

or in calculations

Thank you so much sir, the problem got resolved.
best response confirmed by Safy84 (Copper Contributor)
Solution

@Safy84 , you are welcome

1 best response

Accepted Solutions
best response confirmed by Safy84 (Copper Contributor)