How to return a sub-array based on an array of row indices in Google Sheet?
How do you return a sub-array based on arrays of row indices in Google Sheet?
Example sheet looks like:
A, 1
B, 2
C, 30
D, 4
E, 50
Example inputs:
3
5
which is an array {3;5} representing the row indices of the rows I'd like to make a sub-array of the example sheet.
Desired output:
C, 30
E, 50
which is the array {C,30;E,50}.
Solution
You can just use CHOOSEROWS function:
=CHOOSEROWS(A1:B,TOCOL(D1:D,1))
The TOCOL function is used to skip blank rows (second argument valued 1), otherwise it will give an error in case there are any blanks in the selected range.
- How to return a sub-array based on an array of row indices in Google Sheet?
- Seeking to extract certain including "/"n"p" where n is a digit or may not exist
- Script to convert .XLSX to Google Sheet and move converted file
- Equivalent of “ScreenUpdating” in Google Apps Script (equivalent VBA-GAS )
- How to Extract Both Name and Link from Google Sheets Smart Chip (Place) Using Apps Script?
- How to read a link from a cell in Google Spreadsheet if it's inside href tag (gspread)
- Find first empty row and IGNORE the empty checkboxes - Multiple Sheets
- How to use Google Cloud ADC to access Google Drive API from Python with personal account (not service account)
- Google Sheets: json into columns
- Invalid Range Error Given for data validation rule based on IMPORTRANGE in Google Sheet
- Is there a way to copy from a Google Sheets that is copy locked?
- Google Apps Script gives error "Something Went Wrong" when I try to authorize my own code
- MINIFS with Multiple Conditions
- Find first empty row and IGNORE the empty checkboxes
- Swap the contents of two selected cells in google sheets
- Google Spreadsheet - Not calculating numbers with space
- How to List All Combinations of Values from Two Semicolon-Separated Columns in Google Sheets While Keeping Other Columns Content?
- Adjust onEdit() function to collect results onto one tab (instead of separate tabs)
- Get data from localStorage
- How can I match a smart chip using SUMIF?
- Error submitting data: Failed to fetch, while submitting html css, js form data to google sheets
- How do I cross join two, multi-column tables in Google Sheets — without string hacking or Apps Script?
- Google Apps Script refresh Sheets-Charts not working
- Google sheets, trying to add a cells value to multiple cells
- Email Notification if the IMPORTED DATA in sheet changes. [Triggers not working]
- How to add "custom function help" to a google spreadsheet. - not the script editor
- Google Formula: how to get immediately the first item of a split? Get first result when a formula returns multiple cells
- How to export a csv from Google Sheet API?
- Google Sheets Query Returns All Rows in One Row
- Open Windows Explorer using a google script