Stack Overflow
Stack Overflow

Questions tagged [textjoin]

Use the TEXTJOIN tag for questions that specify it in the question or could benefit from its use in a proposed solution.

Similar to the CONCAT or CONCATENATE worksheet functions, TEXTJOIN allows several cell values and/or string constants to be 'strung together'. TEXTJOIN has an additional parameter for a single delimiter to be used between all concatenations and a boolean option to discard potentially blank cells within a range of text values.

The TEXTJOIN was introduced with Excel 2016 in the following versions:

  • Excel for Android phones
  • Excel Mobile
  • Excel 2016 with Office 365
  • Excel 2016 for Mac
  • Excel Online
  • Excel for iPad
  • Excel for iPhone
  • Excel for Android tablet

It is currently not available within the standard desktop version.

Official support.office.com documentation page at TEXTJOIN function.

337 questions
1
vote
3 answers

Is there a Google Sheets (or Excel) formula like HLOOKUP() but that will search over a two-dimensional range, as opposed to a single row?

I have a Google Sheets spreadsheet and I am hoping to write a formula that finds the location of a given phrase anywhere in the spreadsheet and then returns the value of the cell a certain number of cells below the searched-for cell. For example, if…
Joe North
  • 73
  • 5
1
vote
2 answers

Find IDs that match both values

I'm trying to fetch from a table on another sheet, the IDs that have 2 values in common. At tab Base" I have Name and Date, and would like to have on Lookup the ID's from tab To be fetched that match both Name and Date. Marked in green are the…
Whoopcg
  • 131
  • 7
1
vote
1 answer

G-SHEET lookup with multiple criteria horizontal and vertical

If you could help me finding a formula that would solve my problem that I've been searching for a solution a few days now So in my "feuil 1" I have what I'm searching for according to multiple values -the aircraft number -data 1 -cell number -exit…
abdel ibnou
  • 13
  • 2
1
vote
2 answers

Concat row/column headers for all positive fields in sparse matrix?

For a website internationalization project, I have a Google Sheets with countries and languages that we would like to offer within that country. Shortened sample…
SomeBdyElse
  • 427
  • 1
  • 4
  • 11
1
vote
1 answer

ArrayFormula For Join A Range Column

I want to use ArrayFormula for JoinText for multiple columns, From Column A to Column H. I already have Google App Script for it, and it works. var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("DISPOSISI"); const rowNo =…
PSAB Plalangan
  • 127
  • 7
1
vote
1 answer

Google Sheets IMPORTRANGE with cell variables

I have a google sheet where I import data from another google sheet like this: =IMPORTRANGE("FILENAME", "SHEET1!D166:D180") I have multiple formulas like this in the file that reference different columns in the "FILENAME" sheet. All of the data has…
Eric Augustine
  • 13
  • 2
1
vote
1 answer

How to use ORDER BY in Power BI DAX?

I have a DAX which concatenates values from one column in my data. I want to rank my data by 2 columns right inside my DAX as its concatenating rows randomly. How can I achieve that? My data looks like - Now, the problem is that I've sorted by…
Rhea
  • 43
  • 5
1
vote
1 answer

Return multiple rows of data from INDEX, MATCH, MAXIFS - Google Sheets

Sample Data: https://docs.google.com/spreadsheets/d/1CeksKcxsf10j_hnp7W1MoofBU-sGRp-d8oD_mrj14IY/edit?usp=sharing Long story short, I used the INDEX, MATCH, and MAXIFS functions to return data from another sheet that matched certain…
Emma
  • 13
  • 2
1
vote
4 answers

How to Flip a string in google sheets

I have this google sheets input column on the left, I want to flip the string like shown in the output column. Input Output -------------- bats stab live evil meet teem part trap stop pots
Osm
  • 2,699
  • 2
  • 4
  • 26
1
vote
1 answer

Display multiple cell values in a single cell in google sheets

I made a small algorithm that helps me organize how I study with the Pomodoro studying technique, it displays the amount of hours I'll spend on a single subject, how much I'll spend a day on all the given subjects, in a week, and a month. I want to…
IncognitoSpeedy
  • 37
  • 5
1
vote
1 answer

LOOKUP pickle in Google sheets (adding different payments from different clients and splitting them by month)

I have an issue with the use of LOOKUP formulas for this example: I am trying to determine a way to add different payments from different clients by month This is the worksheet and the information in blue is the desired result (which I am trying to…
bru1987
  • 56
  • 2
  • 14
1
vote
1 answer

Concatinate all matching names dynamically | Google sheets

I want to get the concatenation of the input names according to value like this Name1, Name2,... I tryed this formula but i need to be dynamic with Arrayformula. Make a copy of this example =IF(D3="",,TEXTJOIN(", ",1,FILTER($A$3:$A,$B$3:$B=D3)))
Osm
  • 2,699
  • 2
  • 4
  • 26
1
vote
1 answer

Trouble with unique formula and matching criteria from multiple columns and sheets

My sheet has an agent count page that displays the names and how many times an agents name is on both sheets "IAD(Tampa)" and "Archive Docs". =UNIQUE(QUERY({'IAD(Tampa)'!D3:D; 'Archived Docs'!D3:D},)) =COUNTIF('Archived Docs'!D3:D,A:A) +…
Jon Beckner
  • 57
  • 6
1
vote
1 answer

Combine two cells' data in loop, number the list and skip line

I was wondering what the simplest approach would to be transform my data from column 1 and 2 to column 3. column 1 column2 combined monty, alice monty@gmail.com, alice@gmail.com 1. monty - monty@gmail.com 2. alice - alice@gmail.com matt,…
S C
  • 33
  • 3
1
vote
1 answer

How to use query to generate the result with descending order

Hi I would like to generate the result with descending order. is it possible to use Query achieve this result? or is there alternative way ? Thank…
zongshita
  • 189
  • 1
  • 7
1 2 3
…
22 23