Onion formula | ArrayFormula - CHAR - ROUNDUP - SEQUENCE
In this tip, we are going to explore:
Onion formula | ArrayFormula - CHAR - ROUNDUP - SEQUENCE
All explanations are simple and to the point.
#Shorts #GoogleForEducation #GoogleWorkspace #GoogleSheets
Feel free to make your copy of this spreadsheet template:
https://docs.google.com/spreadsheets/...
Useful Link:
Google Workspace Tutorial:
/ googleworkspacetutorial
Ben Collins (Google Developer Expert & Data Analytics Instructor)
https://www.benlcollins.com/
Google Sheets training:
https://support.google.com/a/users/an...
The Playlist link:
• The most useful Google Apps Tips and Tricks
Follow us on Pinterest:
https://www.pinterest.it/GoogleWorksp...
Our mission is to generate a sequence of letters.
the CHAR function returns A for the number 65.
=CHAR(65)
By adding 1, we get the letter B, and so on.
To generate the numbers, we use this formula
=ArrayFormula(SEQUENCE(10)/2)
Here we add the number of rows that we need.
And here, the number of times the letter is repeated.
By adding the ROUNDUP function.
=ArrayFormula( ROUNDUP( SEQUENCE(10)/2))
We add the number generated by the SEQUENCE function.
=ArrayFormula(CHAR(64 + ROUNDUP( SEQUENCE(10)/2)))
And the mission is done.