In this post, we take a look at How to Use MAKEARRAY Function in Google Sheets. Previously I have covered the word count in google sheets. And also covered how the word occurs into the sheet. And how you can count and show that to the user.
So now I am moving one more step ahead and making sure to add more content in the list of the tutorials specific to the google sheets. Another thing is that if you wish to make changes to some of the examples of these tutorials that would also teach you a lot of new things.
Let's take a look at one of the tutorial where you can learn how to use MAKEARRAY function in Google Sheets.
Let's take an example where you want to make use of the sample data. Like say each column has some random number. We can name these columns as A, B, C. And each of them would contain the random number that is from the 10 to 100. And you can even experiment with this if you want. And now we would move onto making use of the formula.
So we would be making use of the MAKEARRAY formula for this and you can use the content generated out of the formula in order to display the numbers into the columns. You can check it out and see what works and what does not work as per your formula changes.
Here is the formula that you can use.
=MAKEARRAY(10,3,LAMBDA(row_index,col_index,RANDBETWEEN(1,100)))
And you can now use the same into the Google Sheet formula bar. That would give you enough random and raw data that you would be able to make use of for the conent that you can see here. As the MAKEARRAY would allow you to choose the range, LAMBA would choose the random numbers to placed in specific location. And RANDBETWEEN would decide the random number.
As you can see this pretty much works out for your use case. You can experiment with the variety of other combinations and see if that works out. I personally prefer to use it when we have some of the dataset which needs cleanup with specific output and the columns to show as well. In that case you would love how to make use of MAKEARRAY function.
I hope you like the tutorial that I am doing on the YouTube, you can subscribe to that channel if you are interested in this. A lot of Google Sheets tutorials are coming and I am sure you would love making use of the some of the functions that you would see in there. Like, Share and Subscribe if you can.
Thanks for your contribution to the STEMsocial community. Feel free to join us on discord to get to know the rest of us!
Please consider delegating to the @stemsocial account (85% of the curation rewards are returned).
You may also include @stemsocial as a beneficiary of the rewards of this post to get a stronger support.