How to use the Random and vertical search function together in Excel?

We have already seen some of the ways in which we can use the vertical search function. Today I'm going to show a totally different example.

Be sure to download the working file here.

​

If you regularly have to make a certain presentation or possibly some kind of simulation, you can do all this manually.

However, Excel also has a handy function that calls random.

If you combine Random and vertical search, the possibilities become almost endless.

For example, you can enter text or other data in certain ways, which will change regularly using the random function.

If you press F9 or do anything in a cell, a new value will be created every time.

Keep practicing and good luck!

Did you find this video interesting?

Would you like to make a small donation?

Thanks in advance.