Questions tagged [google-sheets-arrays]

Use for questions about using arrays in Google Sheets

8 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
1answer
90 views

Google sheets Xlookup dont work but need results in table the max date on the condition of userlist

Need some help with some data processing. Link of the sheet Example - I need on : Page-2-Seznam članov > Coloumn C : It needs to be the max dates. The function need to search on the liste the ...
1
vote
0answers
191 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 ...
0
votes
1answer
28 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, ...
0
votes
0answers
33 views

Loop through array from importxl in google sheets?

I want to scrape this website[1] for dividend payouts and payout dates (called "utdelningar") in the right lower part. Using the following importxml[2] i get the entire list of dates etc that i want ...
0
votes
0answers
29 views

Passing array from Google Form to script

I've currently a form that a user fills in and the data is then entered into a spreadsheet. All this works well. I now need to make one of the inputs an array so that more than one value can be ...
0
votes
1answer
79 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 ...
0
votes
2answers
1k 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 ...
0
votes
1answer
520 views

Duplicate values in dynamic sorting

I have an issue with duplicate sorting values for a formula in Google Sheets. I'm using two tables to order 10 scores (see pic). The values in Column D are dragged from another sheet. The values in ...