Questions tagged [google-sheets-arrays]

Use for questions about using arrays in Google Sheets

16 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1 vote
1 answer
35 views

How to use ARRAYFORMULA to remove values that contain brackets?

I am trying to write a formula that pulls all data from column A that doesn't contain brackets. Source Data Desired Result (no values containing brackets)
Colin Mills's user avatar
1 vote
0 answers
30 views

Add more conditions to the formula

=query({IMPORTRANGE("1c6ihzJjzD_Nhbz5rB1s0485PS98V-Q4bfVAiIon5vSA","MC2!A11:S5000")}, "select Col19, Col1, Col2, Col3, Col5, Col6, Col7, Col8, Col9, Col10, Col11, Col12, ...
Anastasia's user avatar
1 vote
1 answer
187 views

Import and sum data from multiple sheets

I'm at a loss as to do what I'm wanting. Sheet Main: A B 1 TA 30 2 TB 50 3 TC 12 Sheet TA: A B 1 C .45 2 D .36 3 E .12 Sheet TB: A B 1 C .44 2 G .03 3 R .15 Sheet TC: A B 1 C .10 2 D ...
Cactus Dude's user avatar
1 vote
1 answer
126 views

Why my Arrayformula doesn't work

I have this google sheet : link is here : https://docs.google.com/spreadsheets/d/1_-AcgJud2DclKtarcJj39DNB84CzthUzO_n5F8mBgKY/edit?usp=sharing On the top is my matrix table. It has key on the left ...
andio's user avatar
  • 355
1 vote
0 answers
366 views

Split rows by comma into multiple rows and divide between splits

I have a Google Sheets spreadsheet (sheet 1) which I use as source for a function to split a row into several rows in a results worksheet (sheet 2). The split function divides the row when it finds ...
Jairo Rodriguez's user avatar
1 vote
2 answers
3k views

Consolidate columns from a dynamic range into a single column in Google Sheets

How can Google Sheets take a range of multiple columns and rows and stack or consolidate all the non-empty cells into one column? For this case, I want non-unique cells. Also, each cell in the range ...
Tom's user avatar
  • 163
0 votes
1 answer
151 views

Is it possible to modify with a formula the same cell where you introduce the value in Google Sheets?

So imagine we have column A, B and C. And I want to sum A1 + B1 You can do type in C1 "=SUM(A1,B1)" and you will see the result in C1 But, is there any way we can introduce the formula in A1 ...
Mrquestion's user avatar
0 votes
1 answer
362 views

Make an array expand to the left of the cell with the formula

Is there a way (or workaround) to make an array expand to the left of the cell with the formula? (Above the formula would also work) Here's a spreadsheet with more detail on what I'm looking for. (I'm ...
Phil Anderson's user avatar
0 votes
1 answer
63 views

Google sheets array search

I am trying to write a formula where Cells A2:A16 are searched for numerical values and the results are output in cells C2:F2. Within the data that will populate in A2:A16, there will only be 0-4 ...
Colin Mills's user avatar
0 votes
2 answers
53 views

How to create Google Sheet app that retrieves a mix of random words

I have a Google Sheet with a lot of columns, each of them containing words from a category. I would love to create a formula that can retrieve random words and put them together. For example: Colum 1 [...
Alorve's user avatar
  • 1
0 votes
1 answer
125 views

How can gaps be quantified within a combined set of variable arrays?

I'm using Google Sheets to build a crop planning tool for farmers (kinda like a gantt chart). I need help quantifying the number of days within a given timeframe that no crops are planted in a bed. In ...
Todd Jones's user avatar
0 votes
1 answer
55 views

Search through multiple tabs and pull results

Test Sheet for my use case: https://docs.google.com/spreadsheets/d/1_gcyygG8IhVc-4mXf8n09IFG5ZIYuK_UxWxPLQ5av-k/edit?usp=sharing I've had some input from another user on the site helping me search ...
Willmk's user avatar
  • 1
0 votes
1 answer
32 views

How can I filter several pages of data and ignore those that are blank in the process and return the rest?

Each day I have several tabs that update different football leagues data from websites using importhtml. I filter each individual tab onto one separate tab. When one tab is empty and contains no data, ...
MR H's user avatar
  • 11
0 votes
2 answers
346 views

Move existing SUM downward when IMPORTRANGE expands

I'm building a complex Google Sheets document and for one sheet I use the function IMPORTRANGE. It's very handy and imports new rows from another sheet when they are added. The problem is this: After ...
NLT821's user avatar
  • 1
-1 votes
1 answer
60 views

[SUM IF CELL ABOVE EQUALS CELL BELOW]

[SUM IF CELL ABOVE EQUALS CELL BELOW]. * link to the file https://docs.google.com/spreadsheets/d/1GFS6J1vX88vsOCsKzrMB7Zf82m9QOHqu6oAmO4eJwH8/edit#gid=0 * in column f of the file I'd like to get the ...
Giovanni Capuano Solution's user avatar
-1 votes
1 answer
119 views

How do I convert rows with 45 columns into 15 separate rows, each with 3 columns?

I am working with a google sheet that gets data from an email parser. Each time an email comes in, a single row is created, and fills in these columns: B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q, ...
Adam Park's user avatar