Conditionally Join Texts With TEXTJOIN and IF functions in Excel

There is one function in Excel that I wish Microsoft will eventually release in the future, and that's TEXTJOINIF function, to allow conditionally join texts or cells based on criteria. And since such function does not exist currently in Excel, therefore, I am going to demonstrate how we can use TEXTJOIN and IF functions to join texts together.
Buy Me a Coffee? Your support is much appreciated!
PayPal Me: www.paypal.me/...
Venmo: @Jie-Jenn
To download the exercise file: drive.google.c...
More tutorial videos on my website → LearnDataAnaly...
Supporting my channel so I can continue keep making free contents
-------------------------------------------------------------------------------------------------------------
By shopping on Amazon → amzn.to/2JkGeMD
By become a member on Patreon → / jiejenn (Will gradually adding more benefits as I see fit)
#ExcelTutorial #TEXTJOIN #IF

[@andreasbillepetersen6786]

Thank you! I had an issue where I tried combining Textjoin with Offset. This did the trick for me!

[@jiejenn]

Glad it helped!

[@GabrielRodriguez-ql7uj]

Thank you!

[@nickynicku9795]

Thanks! Just what I needed.

[@jiejenn]

Glad the video helped.

[@ravishete2602]

Just Fantastic!!!

[@amyc1438]

Thanks!

[@vanessaateixeira]

PERFECT!

[@haroldquek1655]

Are u able to do a video on this in vba?