Vlookup and Array formula in Google Sheet
Topic Breakdown
Lesson 1 - Introduction to Googlesheet ( • Introduction to the Google Sheet Series )
Lesson 2 - Vlookup, ArrayFormula ( • Vlookup and Array formula in Google S... )
Lesson 3 - Index(Match ()) ( • Index Match in Google Sheet )
Lesson 4 - Unique Countif and Countifs ( • Unique, Countif and Countifs in Googl... )
Lesson 5 - Filter, Indirect, and nesting Filter in other functions ( • Filter and Indirect Google Sheet )
Lesson 6 - Query (Select, Where, Order by, Group by, Limit) ( • Query on Google Sheet: Select,Where,G... )
Lesson 7 - Appscript Part 1 (Copy Pasting Data) ( • Transferring Data using Google App Sc... )
Lesson 8 - Appscript Part 2 (Report Generation with Text Replacement) ( • Batch Create Reports with App Scripts )
Link to Spreadsheet: http://bit.ly/Brandon_Yeo
Linking Googlesheet with R
• Googledrive and Googlesheet4 in R | A...
Link to Example Datasets:
Iris: https://gist.githubusercontent.com/cu...
Cars:
https://gist.githubusercontent.com/no...
Email: [email protected]
Github: https://github.com/brandonyph
Twitter: / brandon_yeoph