Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with regexextract
Search options not deleted
user 246259
For questions about a spreadsheet function that allows selection from a string on the basis of a regular expression.
1
vote
0
answers
163
views
Why 2 columns of the same value give different total?
Sample Data in Result Sheet
I have a formula in A2 that extracts data & splits it into unit & product (A & B).
I used the SUMIF formula to give the the total of each separate set of product from A, bu …
- 383
0
votes
1
answer
654
views
Combine an array formula with query function
B2:B = "not paid")),"", 9^9)," ")),"_", " "))
Then, this splits that col. into unit & name: =ArrayFormula(if(len(A3:A), trim(regexextract(A3:A, "^(\d+)\s(.*)$")),)) Also in col. … error:
=QUERY('*formula2*',"SELECT E, SUM(F) GROUP BY E")
=QUERY(E3:F856,"SELECT E, '*formula2*' SUM(F) GROUP BY E")
And also, embed formula 1 into formula 2:
=ArrayFormula(if(len(*'formula1'*), trim(regexextract …
- 383
1
vote
1
answer
1k
views
Regexextract to get a text in the middle of string
- Product Name here - PAID IN FULL
=arrayformula(REGEXEXTRACT(A2:A3, "[^(\d)\s+]. … (REGEXEXTRACT(A2:A4, "[^(\d)\s+].***[-$]**"))
result: …
- 383
1
vote
2
answers
662
views
Extract Data from 2 columns if it matches condition
This is how my main data sheet looks like
And for any item that has customization, for e.g. - ORGANIC, I want to extract/copy just those data, the meal name & total units to another sheet.
And then t …
- 383
1
vote
Extract Data from 2 columns if it matches condition
Finally found the answer to this:
=TRANSPOSE(FILTER(A2:B17,ISNUMBER(SEARCH(G9&"* - *",A2:A17))))
- 383