Posts Google Sheet - Query Function - missing from Microsoft Office
Post
Cancel

Google Sheet - Query Function - missing from Microsoft Office

Runs a Google Visualization API Query Language query across data.

1
2
3
QUERY(A2:E6,"select avg(A) pivot B")

QUERY(A2:E6,F2,FALSE)

https://support.google.com/docs/answer/3093343

origin - http://www.pipiscrew.com/?p=5979 google-sheet-query-function-missing-from-microsoft-office

This post is licensed under CC BY 4.0 by the author.
Contents

Trending Tags