Skip to main content
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
Search options not deleted user 211080

For questions about Google's web application to create and edit spreadsheets on a web browser or app. Don't use it for the Google Drive Excel files editor. Please consider adding data as markdown table to your question; this will greatly increase the chance that you get a satisfactory answer.

0 votes
1 answer
3k views

Is there any way to let the data range of a chart in Google Sheets dynamically adjust?

Say I have a table like this: | Date | Number | | 0128 | 28800 | | 0129 | 32500 | | 0130 | 63410 | | 0131 | 56400 | | 0201 | 68700 | | 0202 | 84060 | And I can put a graph to sho …
darkrose1977's user avatar
1 vote
1 answer
50 views

How do I arrange raw data in Google spreadsheet in group way?

I have a list of orders, like this: Paid $28.00 | 2019-04-08 15:14:20 Unpaid $00.00 | 2019-04-08 15:13:48 Unpaid $00.00 | 2019-04-08 15:12:58 Unpaid $00.00 | 2019-04-08 15:12:10 Paid $18.00 …
darkrose1977's user avatar
1 vote
1 answer
2k views

ImportXML not stable in Google Sheets, how can I improve that?

I have ImportXML in my spreadsheet. I am tracking the Alexa ranking of a list of websites. Here is the formula: =HYPERLINK(CONCAT("www.alexa.com/siteinfo/",A4), value(ImportXML(CONCATENATE("http:// …
darkrose1977's user avatar