textjoin

This is harder to explain than show. I have metadata being imported into an Excel spreadsheet that defines a single item (an image title) on a given row, but much of the metadata is in separate columns with each column cell containing data that is separated by delimiters (;). These are all...

Hi, I have made an Excel function to return all matching results from a column and separate them by a bullet point and two return lines. Is there a way to update the Excel function to not include a bullet point if there is only one returned value from the TEXTJOIN? I know I have the CONCAT a...

Hi, I'm struggling to find a way to make some textjoin alike formula with IF condition and also "unique" too in order to combine results that share same value. I have something as per below example: ID Type Name1 Type1 Name1 Type2 Name2 Type2 Name3 Type1 Name4 Type1 Name4 Type1...

Hi, I'm hoping someone can help me. I apologise in advance as it might take me a bit to explain what I need. I'm trying to dynamically/automatically add new rows underneath the existing row that contains a FILTER formula that is working across multiple sheets. I will try my best to explain...

I really don't know how to state this one better. I'm creating a spreadsheet that will take a customer's email address and Generate an email to inform them who the contacts for their selected job area are. I designed a sample spreadsheet: And my goal is to produce the email so it has a link...

I want to get a summary of the unique value under a condition. Like in the below table- 1. For article BD-01, the Sorted (A-Z) unique area code is 11, 12, 15. 2. Then for these Unique codes, there are some product codes. 3. Now I want to Join all Area code and their Product codes with separator...

I got TextJoin to work in a cell and within code as shown below. What I need to do is to go to the next step, which would be populate the rest of the rows in column C based on values in columns A and B. The number of rows is an unknown. I assume I'd need a Loop or something, but I'm not that...

Hey everyone, I have this excel table in Column A and B, but I want to bring into the form of D and E: ABCDE1KeyActualCategoriesKeyActualCategories21IT-Strategie1IT-Strategie32IT-Strategie2IT-Strategie43IT-Strategie3IT-Strategie54Vorgaben&Maßnahmen4Vorgaben&Maßnahmen65IT-Strategie5IT-Strategie...

I have 2000 item numbers in a column that I was able to get into a delimited row with commas. I was wondering how to break these into groups of 30 item numbers. I was using =TEXTJOIN(", ",,A1:A30) =TEXTJOIN(", ",,A31:A60) ETC. It works great but super tedious. Any suggestions? Thank you

Hi, I seem to be having error when using Textjoin. The worst part is that it was working fine, but file didn't saved and when I tried to replicate the formula, I keep getting now error Calc and cant see where is the issue. I have few tables, consisting of 2 columns each. 1 column has list...

Is it possible to have a cell or a range of cells dynamically report the contents of a range of cells from another sheet based on a criteria? ie: SUMIF works great for finding cells in a table that are adjacent to cells matching a specified value, but that's only useful if they are numerical...

Hi, I am trying to find the way to obtain a list of values in same cell, based on 2 conditions. I seem to be struggling with the right way based on below formula: =TEXTJOIN(", ",TRUE,UNIQUE(FILTER(ColumnB,(ColumnA=A2)*(ColumnC="Yes"),""))) for some reason i obtain only 1 result instead of...

I am attempting to pull the categories that names are found in, and have it working all but for blank/missing names. =TEXTJOIN(", ",TRUE,UNIQUE(IF(ISNUMBER(SEARCH(A1,'Master'!C:C)),LEFT('Master'!A:A,4),""))) The cell "A1" is blank, and I am trying to pull the results (first 4 left characters...

I am trying to TEXTJOIN to create links to my filepaths, whilest adding text that I need - but I don't want it to bring back anything when I have no vaule. Any help would be massivly appriciated. ABCDEFGHIJKLMNOPQRSTUV1File PathStyle...

Hi there, I want to create a table where a user can enter data for a 'Stock Alert Message'. The data entered will consist of a Stock Code, Group, Type and Category. I would then like to run a query against this table which will only show us Stock Items which have an alert. I'm struggling with...

Hello all! I have a question regarding looking up similar companies. For example, in my database, there is AXA Asia, AXA Group or AXA Company Limited. I will look up AXA with search function and filter them out. My formula is like this...

I want top 3 Unique students ranking filtered from records below along with their details and all the other roll numbers excluding the ones that are once already mentioned once in the left Only that appeared on top 3 in the last column (with Comma separation) D1125A8:I20,J11:N20Cellcontains a...

I am trying to create a report we will run daily for a different individual each time (B10). We'll export a report that has about 7000 lines, a sample of which is shown in E2:G12 below. I got farther than I thought (I can exclude the person the report is run for, B10) but now I am unable to...

Hello everyone, this is my first thread here in this forum. For quite some I am using excel now with great fun and passion. Thanks to this forum I was able to solve many obstacles when I got stucked. However, today I really need to ask for help as I am stucked for a few days already. So here...

I'm pretty sure that there are lots of threads on this, but all of the threads that I have read through I can't get the formulas to translate to what I'm trying to do for some reason. I'm still really new to all of this and I've watched countless videos and I just can't get it. What I'm trying...