Apr 30 2021 02:10 AM
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.
Apr 30 2021 02:32 AM
Apr 30 2021 02:48 AM
Apr 30 2021 03:58 AM
You may round result in this formula
=TEXTJOIN(",",TRUE,IF(1=ROUND(F$38:F$59,5),$A$38:$A$59,""))
or in calculations
Apr 30 2021 04:05 AM