The Memory Bank

...for memory blanks

User Tools

Site Tools

Trace: • remove_version_lock_pkg • setrunlevel
google_sheets

Differences

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

Link to this comparison view

google_sheets [2025/01/19 21:48] – created kengoogle_sheets [2025/01/19 21:48] (current) – ken
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