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 microsoft-excel
Search options answers only
not deleted
user 269219
Questions with this tag should ONLY be about how Microsoft Excel interacts with a specific web application. General questions about Microsoft Excel are off-topic here but can be asked at Super User.
0
votes
Google Sheets: return multiple values of substring search
To get a list of the row labels in column A, the column labels in row 1, and the matching value, use this pattern:
=arrayformula(
lambda(
rowLabels, columnLabels, data, searchKeys,
lambda …
- 15.7k
2
votes
Accepted
Keeping referenced data organized after sorting
You should not blindly trust that each name will continue to be at the same row number on every sheet. Use a vlookup() or filter() instead. Try this:
=sum( iferror( filter(Earned!B$2:ZZ, Earned!A$2:A …
- 15.7k
1
vote
How to sort unique cells in order of appearance on google sheets?
One way is to use the query() function:
=query(A1:A, "select A, count(A) group by A order by count(A) desc", 0)
This has the benefit that it also shows the counts per value.
If the column has a header …
- 15.7k
1
vote
A way to "lock" and "unlock" a Google Sheet's contents
An editor of a spreadsheet cannot modify sheets or ranges that have been protected from edits. However, if they are the owner of the spreadsheet, they can always edit any cell directly. The exception …
- 15.7k
1
vote
Formula to count the text in a rang of cells (with formulas)
Use this pattern:
=counta( iferror( filter(A2:A, len(A2:A)) ) )
Alternatively, modify the formula cells you are counting so that the formulas return truly blank values iferror(1/0) instead of zero-le …
- 15.7k
3
votes
Accepted
Does importrange not work on Google Sheets embedded XLSX files?
The importrange() function can only read data from Google Sheets and therefore cannot read data from Microsoft Excel files, even though you can view and edit such files with Google Sheets. I do not th …
- 15.7k
0
votes
Accepted
Use MATCH & LARGE but with 2 identical highest values in Google Sheets
Use sortn(), like this:
=sortn(
transpose(AM1:BL1),
5, 0,
transpose(AM3:BL3),
false
)
To join those results into one text string, use textjoin(), like this:
=textjoin(
", ", true,
…
- 15.7k
0
votes
Return a list if 2 criteria match in Google Sheets
Your data table looks nice and pretty — i.e., it is like a report.
The best practice is to keep your data row-oriented and simple, and create reports separately — do not try to make your data look lik …
- 15.7k