TEXTJOIN and Dates | MrExcel Message Board
Nov 4, 2015 · You need to apply the TEXT function, using the date format you want, to the individual dates that are being joined. If you had posted your TEXTJOIN formula, we could …
Textjoin and Filter using VBA | MrExcel Message Board
Jan 10, 2014 · I have the following Array and I'm trying to use TextJoin and Filter in VBA to combine the elements of the array and place it in one cell Farmer John Apples Oranges …
TEXTJOIN with an Array - Excel Tips - MrExcel Publishing
Mar 6, 2018 · TEXTJOIN accepts 3D references As someone who used to use CONCATENATE a lot, TEXTJOIN is the one function that I truly miss when I am on an older version of Excel.
How to use TEXTJOIN in vba | MrExcel Message Board
Jul 9, 2010 · Is there a way to use TEXTJOIN in vba? Click to expand... I don't have a version of Excel that has TEXTJOIN in it, so this is just a guess. If the WorksheetFunction does, in fact, …
TEXTJOIN with IF Statement VBA | MrExcel Message Board
Apr 28, 2022 · TEXTJOIN Function was introduce with the release of Excel 2016. This is very helpful function to join the multiple text into one. The best thing is that it allows us to select an …
Unique, Textjoin, Filter all in one formula - MrExcel
Nov 7, 2008 · Hi all, My first thread here i think.. I have been trying to get my head around how to do something with the new 365 functions, below i have used a seperate unique formula to …
TEXTJOIN alternative for older versions? - MrExcel
Aug 2, 2022 · Hi all, new poster but at my wits end with TEXTJOIN function. I created a spreadsheet for staffing and had it functioning at home in Office 365 using the TEXTJOIN …
Filter and Textjoin to return multiple results in same cell
Dec 7, 2022 · I am trying to arrange data from three columns into a matrix which uses the unique values of two of those columns ("Department" and "Grade") to identify all of the values of that …
Text Join and FILTER with multiple criteria - MrExcel
Oct 2, 2021 · Hi All, I need help to find the right way to combine "Text Join" and "Filter" function but with multiple criteria: I have tried the text join and filter...
Formula to sum a text join based on multiple Criteria
Feb 12, 2020 · Don't use textjoin, have 2 separate columns, 1 for each of the 2 week numbers. Then it's a simple sumifs formula.