All Questions
6 questions
1
vote
1
answer
224
views
Search Contents of Multiple Rows For Specific Text Using Array Formula in Google Sheets
I have a column where each row contains multiple words, example below:
Fight; (People: Jack, Gil, Row, Pitt); (Link: Box, Wave, Line, Guard, Circle, Wide, Arrow,)
Fight; (People: Jack, Clive, Gareth); ...
- 37
1
vote
1
answer
820
views
Google Sheets - Find the lowest values in the entire table line by line
I can't find a way to make ArrayFormula and SMALL functions work together using the built-in Google sheets functions.
I have a table1 with items and their prices. Each position has the lowest price ...
1
vote
1
answer
841
views
Multiple links to hyperlink string (Split and concatenate with ArrayFormula)
I'm trying to figure out how to make a formula to turn links in one cell into hyperlinks in another
From cell A1, A2 etc I'm trying to get cell B1, B2 etc using the Split and concatenate formulas. But ...
- 27
1
vote
1
answer
57
views
gSheet - Unable to get results using filter in an array
I'm trying to reference data that has multiple matches using an array formula.
It's not able to find any data. Yet if I change "DTR!C:C=B:B," to "DTR!C:C=B6, B7, etc," and use the ...
- 13
1
vote
1
answer
79
views
Google Spreadsheet ArrayFormula + VLookup Transformation
I have the following table on Google Spreadsheet:
And would need to get the following transformation result:
I precise that for each vegetable i can have only 1 buy price, and 1 or several sell ...
- 25
1
vote
1
answer
381
views
Dynamic data CONCATENATE inside ARRAYFORMULA in Google Sheets
I have a (dynamic) dataset in column A, which I need to be merged individually with each of the data in column B. I have tried combining CONCATENATE/SPLIT/TRANSPOSE... with no luck = (
As far as my ...
- 69