Create a Column of Random Numbers in Google Sheets with One Formula

Опубликовано: 17 Август 2022
на канале: Sheets Help
1,638
13

Learn how to generate a column of random integers using the built-in functions in Google Sheets. First, we will create an array, then fit that array to the right number of rows, then turn the decimals into integers.

Blog post: https://sheetshelp.com/column-of-rand...

Timestamps:
0:00 Intro
0:30 Create an array of decimals
0:50 Extend that array
1:47 Convert the decimals to integers
3:42 Convert from dynamic to static
4:25 Next video - data types and their formatting

#googlesheets #spreadsheet #random