Questions about textjoin
Read more about textjoin
python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
How to exclude multiple strings from SUMIFS
I have this formula here:
=SUMIFS(SalesData!$N:$N, SalesData!$B:$B, "FirstName LastName", SalesData!$D:$D, "<>"&A1:M1)
But the last part "<>"&A1:M1 d...
ThatBraxGuy
Votes: 0
Answers: 1
Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered " <ID> "s "" at line 1, column 2168
My exact formula below used to work previously and without changing anything except adding more data to my master table whereby 'Premium Advertisers' is populated, I get the following error:
"Una...
TheReibahs
Votes: 0
Answers: 1
How to add condition to Array to concatenate Columns A&B only if Column B value is not blank?
Trying to display output of columns A & B when value in column B is present in a single cell.
I can join all of the non blank value in column B by using textjoin, combining a filter & an array...
MMsmithH
Votes: 0
Answers: 1
conditional formatting entire row if all cells in that row are empty
I'm trying figure out how to apply style to all rows, but only when entire row is empty, basically if any cell is not empty, the entire row should be skipped.
tried =AND(ARRAYFORMULA(ISBLANK(A1:Z))) i...
vanowm
Votes: 0
Answers: 1