The Ultimate Guide to Creating Lists in Google Sheets
In this video, we'll create 30 different types of list, including numbered lists, date lists, text lists, emoji lists, and row count lists. We use the SEQUENCE function, array formulas, and even some of the modern LAMBDA style functions to create the lists.
📚 Additional resources:
Template to follow along: https://docs.google.com/spreadsheets/...
SEQUENCE function reference: https://www.benlcollins.com/spreadshe...
ArrayFormula reference: https://www.benlcollins.com/spreadshe...
CHAR function reference: https://www.benlcollins.com/spreadshe...
MAKEARRAY function reference: https://www.benlcollins.com/spreadshe...
📖 Chapters:
0:00 - Introduction
0:29 - Numbered lists
1:32 - Descending lists and negative numbers
2:21 - Grouped lists e.g. 1,1,1,2,2,2,3,3,3
7:56 - Decimal count lists
8:41 - "1 of X" type lists
9:54 - Date lists
13:37 - Time lists
15:38 - Letter lists
17:22 - Lists with emojis
18:51 - Row count lists
✉️ Google Sheets Tips Newsletter, my free weekly newsletter:
https://www.benlcollins.com/google-sh...
#googlesheets #googlesheetstutorial #spreadsheet
Watch video The Ultimate Guide to Creating Lists in Google Sheets online, duration hours minute second in high quality that is uploaded to the channel Ben Collins 09 January 2024. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 5,212 times and liked it 118 visitors.
