Random selection from a list in Excel

Published: 04 April 2019
on channel: Strategize Financial Modelling
17,333
34

This video will look at one approach to generate random, yet specific values from a list in an Excel spreadsheet. We have a list of companies, which we want to generate random sales volumes for.

Many Excel users will be aware of the RAND() function, which can generate "an evenly distributed random real number greater than or equal to 0 and less than 1." (as per the Microsoft website).

However, what if we want to generate random, yet specific values in a spreadsheet?


Watch video Random selection from a list in Excel online without registration, duration online in high quality. This video was added by user Strategize Financial Modelling 04 April 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 17,333 once and liked it 34 people.