textjoin

For example I have a list of 100 words in excel from A1 - A100 I need to use a formula to be able to output the words in a line with the Word "OR" in between The output I would like would be is "word1 OR word2 OR word3 OR word4" I believe this can be done using the text join Formular...

referring to a cell by OFFSET(INDIRECT(ADDRESS(ROW();COLUMN()));0;-4) is easy Although I want to replace "$H:$H" in a formula by an OFFSET function referring to the entire column 4 columns to the current cell (column) How can that be done? example: =TEXTJOIN(", ";TRUE;IF($H:$H = E5;$I:$I;""))...

Hi, I am struggling to make Textjoin work with an additional criteria. =TEXTJOIN(", ",TRUE,UNIQUE(FILTER(RawData[ID],RawData[Issue Status]="",""))) I am using the above code, which works, but then i want to use the same one, but adding an additional condition, which should be the below...

Hello, I'm trying to use the textjoin function to combine multiple dates into one cell and ignore blank cell. I was able to get to work using this function =TEXTJOIN(",",TRUE,D8:P8) but it brough the dates over in a number format like 44655, 44683, 44718. I want it to look like this 4/4/22...

Hi All, I have a three sheets, Sheet 1, Sheet 2, Sheet 3. Sheet 1 has Id's and email addresses columns, Each Id has many emails, sometimes blanks too,. Each Id has multiple rows in Sheet 1. Sheet 2 has list of keywords words to use as exclude lists for email addresses. Sheet 3 has Id's, and...

Hi, I'm trying to automatically categorize a large amount of products by finding keywords in the product descriptions. Using a textjoin, if, count if fucntion works perfectly because if mutiple keywords match, it indexes all of them. But these products come from a range of different suppliers...

Hi all, Hope someone can help me figure out why i am not getting the right outcome from the formula. I am trying to obtain some kind of summary, based on a vlookup for a person. So the idea is that by lookup the person name, then i will get 3 columns, providing different details connected to...

Hi Everyone, Thanks in advance for any help I may get. I have a working index match formula with one drawback. If I get multiple results, currently only the first result takes priority. I'd like to show all returned results in the same cell, and I see many posts about using textjoin to do it...

Hello, So I am trying to use the formula to join all of the data from 1 sheet into a cell if there are multiple rows with the same data on. It work's for the most part, however the date I want to join together are all percentages, and it keeps joining the data not in a percentage format... Is...

My title might be confusing. So, here goes. I'm attempting to create a summary sheet of sorts for a weekly schedule. There are multiple tables throughout the workbook that represent days of the week and tasks for each day. View a portion of one of those tables in my "Thursday" tab below: I...

Hi, I'm trying to use the Textjoin function in VBA. I know how to do it for the first row, but I'm having issues when I want it to apply for the whole column. For example, I want it to start at AH2 and the formula on the cell should be =TEXTJOIN("-",TRUE,I2,AE2,AF2,AG2). For AH3 the formula...

I have a three-sheet workbook intended to distribute tasks to employees. Sheet1 is a dashboard, Sheet2 is a table with primary tasks (some 1000), Sheet3 is a table with secondary tasks (some 1300). The employees are imported from another workbook via a PW-protected button as new sheets that they...

I have a few tables of data and I am trying to pull some information in Column F, based on the contents of Column A, into a cell on a different tab with TEXTJOIN. I need it in 2 different formats for different things. I made a sharable sheet with no company info and reduced the dataset for...

I wonder if you can suggest a solution for this business question: A given value created to be a matching lookup key between tables can have multiple records in a transaction file. I need to find the condition where the Lookup value has “conflicting” (different) values in another column between...

Ok, I don't think what I'm trying to do is unique, but I certainly can't seem to work it out or find any examples, or even failing that, think of a better way. Sheet One contains cells with Action Groups. These cells might have one action group per cell, or multiple action groups per cell, such...

Hi there, This is my first post since I am lost. Thanks for setting up this site! I received this huge sheet with a list of projects in column A. Each Project uses Deliverables (Columns B to Z+). The goals are: - Find total $-amount spent on deliverables for each KEYWORD found in row 2. -...

Hi, I am looking for a VBS/ formula for the following. Here I am trying to achieve Dynamic Lookup for multiple values in a cell (comma separated) and return the corresponding values to a single cell (comma separated also). I am able to populate the B13 through the formula with Barnames column...

Hi, I am looking for formula in excel for Dynamic Lookup for multiple values in a cell (comma separated) and return the corresponding values to a single cell (comma separated also). Here is the example. 90 Here, I have an input table in sheet 1 and I am looking for formula to get the output...

Hello Everyone, I don't know if this is possible but I'm hoping someone can help. I have a set of data in the A column that is all linked to one piece of data. Within that data has multiple numbers. For instance, I'd like a formula to pull every number next to tire onto each article. I would...

I have the following function which works great on my laptop with the updated version of excel, however my computer at work has an older version and textjoin results in a NAME error. These are the functions =TEXTJOIN(", ",,IFERROR(SMALL(IF(E5:AA5=0,$E$1:$AA$1),{1;2;3}),"")) and =TEXTJOIN("...