textjoin

  1. A

    using OFFSET to refere to entire column (eg. $H:$H)

    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;""))...
  2. D

    TextJoin with 2 criteria

    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...
  3. E

    Textjoin dates and ignoring blanks

    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...
  4. M

    Match, Filter, unique, text join, search combination

    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...
  5. Q

    categorize text strings by keywords and their synonyms with textjoin, if, countif

    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...
  6. D

    Help with TextJoin and obtain Unique values (remove duplicates)

    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...
  7. B

    Index Match with multiple results using Textjoin

    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...
  8. M

    TEXTJOIN with IF conditions, but not showing correct format?

    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...
  9. L

    Textjoin multiple columns based on unique values in first column and highest value in another column

    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...
  10. S

    VBA - Textjoin for the whole column

    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...
  11. P

    Multi-variable lookup across range of variable sheet count

    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...
  12. S

    2 TEXTJOIN problems - remove duplicate/only unique output, and remove '0' from conditional IF results

    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...
  13. C

    Equivalent of TEXTJOIN in Power Query

    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...
  14. L

    Is this possible? VLOOKUP, CONCAT, TEXTJOIN, LEFT, help!

    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...
  15. A

    List projects based on keyword in column headers, then return them and mark maximum minimum spent

    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. -...
  16. H

    VBA - Multiple values in a cell (comma separated) and return the corresponding values to a single cell (comma separated) with characters more than 255

    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...
  17. H

    Dynamic Lookup for multiple values in a cell (comma separated) and return the corresponding values to a single cell (comma separated also)

    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...
  18. B

    Formula to pull multiple matches on multiple criteria

    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...
  19. J

    Alternative to textjoin for this function to work

    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("...
  20. J

    Textjoin: To show distinct and ignore blanks

    Need help to get only distinct values from a list using Text Join ID Sequence Task 1 0.1 Task 1 0.2 Task 1 Task 1 0.1 Task 2 0.1 Task 2 0.1 Task 2 0.3 Task 2 Trying to get only distinct values from Sequence column for its...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top