SOLVED

TextJoin function is not working - Looking for prompt solution

%3CLINGO-SUB%20id%3D%22lingo-sub-2309809%22%20slang%3D%22en-US%22%3ETextJoin%20function%20is%20not%20working%20-%20Looking%20for%20prompt%20solution%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2309809%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20the%20attached%20excel%20TextJoin%20function%20returns%20no%20value%20in%20the%20yellow%20marked%20cells%20where%20in%20the%20same%20formula%20returns%20value%20in%20the%20blue%20marked%20cells.%3C%2FP%3E%3CP%3EI%20am%20not%20able%20to%20figure%20it%20out...%20pls%20help%20to%20sort%20out%20this%20issue.%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2309809%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2309867%22%20slang%3D%22en-US%22%3ERe%3A%20TextJoin%20function%20is%20not%20working%20-%20Looking%20for%20prompt%20solution%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2309867%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F712501%22%20target%3D%22_blank%22%3E%40Safy84%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EF39%20an%20G39%20don't%20contain%20a%201%20but%26nbsp%3B0%2C999999999999999.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2309945%22%20slang%3D%22en-US%22%3ERe%3A%20TextJoin%20function%20is%20not%20working%20-%20Looking%20for%20prompt%20solution%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2309945%22%20slang%3D%22en-US%22%3EThank%20u%20for%20figuring%20out%20the%20problem%20area.%20But%20unfortunately%2CF39%20%26amp%3B%20G39%20returns%20the%20value%20from%20F42%20to%20F66%20%26amp%3B%20G42%20to%20G66%20which%20is%20the%20rank%20formula%2C%20so%20getting%20decimal%20is%20not%20possible%20there.%20Can%20you%20pls%20help%20to%20sort%20this%20further%20too.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2310233%22%20slang%3D%22en-US%22%3ERe%3A%20TextJoin%20function%20is%20not%20working%20-%20Looking%20for%20prompt%20solution%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2310233%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F712501%22%20target%3D%22_blank%22%3E%40Safy84%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20round%20result%20in%20this%20formula%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DTEXTJOIN(%22%2C%22%2CTRUE%2CIF(1%3DROUND(F%2438%3AF%2459%2C5)%2C%24A%2438%3A%24A%2459%2C%22%22))%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Eor%20in%20calculations%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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 (Occasional Contributor)
Solution

@Safy84 , you are welcome