Random Sample

I'm thinking this would be a lot for a formula as the one to use would be Rand() which is volatile. My thought is to use code that way you can do this time and time again without having to go thru the trouble with formulas. What do you think about VBA?

Anyway, here is a link to give you an idea about a formula method.

https://www.uwec.edu/help/excel07/randomdata.htm

So glad it worked out for you and thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.