Technical > Gsheets
Functions
There are literally 100's of built in functions in spreadsheets. These are the most used functions for database-ish use of spreadsheets
There are literally 100's of built in functions in spreadsheets. These are the most used functions for database-ish use of spreadsheets
- Query - Filter - Retrieve one or multiple rows of data with one or multiple columns, of data given specific criteria. Comparable to Select statement calls in SQL
- Index - Match - Lookup - Retrieve one cells worth of data or meta data given specific criteria. Comparable to a limited select call in SQL and/or comparable to finding an index for a value in an array of values.
- Arrayformula - Conditionally fill rows, columns or rows and columns with data based on specific criteria and data in other cells
Knowledge Base
The links above provide limited information about a few of the most used functions for using a spreadsheet for database type applications. This link to the right goes to a shared gDrive directory / Knowledge Base where there are individual files for the functions listed above plus many more files that detail numerous use scenarios, notable issues, and nuances. Please note, the files are .js (javascript) files. The do not execute anything. I use a programming text editor to take/make notes and I name the files .js files out of habit. Think of these as text files and open in text editors. |