Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [syntax]

Apply to questions specifically about the structure required for commands to be recognisable for triggering appropriate actions. These questions will normally require a tag for an app or programming language in addition.

0
votes
1answer
17 views

Google Sheets IMPORTHTML parse error

I want to use the IMPORTHTML function of Google Spreadsheets. There is this example by Google itself: =IMPORTHTML("http://en.wikipedia.org/wiki/Demographics_of_India","table",4) Unfortunately (like ...
0
votes
1answer
17 views

Enter Tab Name In Cell To Calculate Sum of Column or Range

I have seen one other similar question on this topic posted a few years ago, but I have been unable to have any success with the suggestions given there. I have sales sheets (a new one added each day)...
0
votes
1answer
29 views

spreadsheet conditional: if in top x then

spreadsheet data: Total Average Highest Top Sales $23,550.00 $7,850.00 $8,100.00 not $42,700.00 $14,233.33 $14,400.00 not $30,500.00 $10,166.67 $10,300.00 not $37,840.00 $12,613....
1
vote
2answers
664 views

QUERY error for BY column

I'm using the following query to pull data from one sheet into another. =query(data!B2:CL,"select B, C, D, E, F, G, H, I, J, BB, BZ, CA, BA where J = 'Industry Certification'",false) The above query ...
-1
votes
1answer
95 views

Word merge syntax

So I have been having a blast developing user friendly forms to fill out rather arduous documents lately, but as I have been experimenting with repeating sections, getting them to import properly has ...
2
votes
1answer
1k views

What is the exact syntax for linking to a Facebook ID?

Until recently, it was possible to link to pretty much anything which has a Facebook ID using syntax like this in status updates, comments, chat messages and probably elsewhere: @[398643386827709:...
4
votes
2answers
5k views

URL syntax and display options?

I recently came across a Google Sheets that had a slightly different syntax in the URL. I found these tags after the Spreadsheet Key: &single=true&gid=0&range=B5%3AB5&output=html I ...