The Memory Bank

...for memory blanks

User Tools

Site Tools

Trace:
google_sheets

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
google_sheets [2025/01/19 21:48] – created kengoogle_sheets [2026/01/16 03:37] (current) – external edit 127.0.0.1
Line 4: Line 4:
 <code> <code>
 =QUERY(A1:B, "SELECT B WHERE A='Mango' LIMIT 1 OFFSET 1", 0) =QUERY(A1:B, "SELECT B WHERE A='Mango' LIMIT 1 OFFSET 1", 0)
-</code.+</code>
 If your data has a header row, you should use it as follows: If your data has a header row, you should use it as follows:
 <code> <code>
 =QUERY(A1:B, "SELECT B WHERE A='Mango' LIMIT 1 OFFSET 1 LABEL B'' ", 1) =QUERY(A1:B, "SELECT B WHERE A='Mango' LIMIT 1 OFFSET 1 LABEL B'' ", 1)
 </code> </code>
google_sheets.1737323282.txt.gz · Last modified: (external edit)

Page Tools

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki