LinkBack URL
About LinkBacks
Anyone have the new TEXTJOIN function?
Will it accept conditional array arguments?
=TEXTJOIN(",",TRUE,IF(A1:A5="Yes",B1:B5))
I assume that would have to be array entered.
Anyone have the new TEXTJOIN function?
Will it accept conditional array arguments?
=TEXTJOIN(",",TRUE,IF(A1:A5="Yes",B1:B5))
I assume that would have to be array entered.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks