Skip to content

Instantly share code, notes, and snippets.

@LemonPi

LemonPi/mode_docs_spreadsheet

Created February 24, 2017 10:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save LemonPi/a477dbc5b0cd87f14e29a33f5a805881 to your computer and use it in GitHub Desktop.
Save LemonPi/a477dbc5b0cd87f14e29a33f5a805881 to your computer and use it in GitHub Desktop.
Download ZIP
Google Docs query for listing rows by occurance
Raw
mode_docs_spreadsheet
=query(index(if({1,1},upper(D3:D24)&"")),"select Col1,count(Col2) where Col1<>'' group by Col1 order by count(Col2) desc",0)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment