If you need to sample a set of data, the Random Sampler add-in will quickly and easily obtain the samples for you. The first group of three options is designed for small databases. The second group of three options can handle millions of rows across many worksheets. We ran a test of extracting 8,000 samples from a group of worksheets containing close to three million data rows. The Random Sampler did the task in 30 seconds.
||Free to try
||Microsoft Excel 97-2010.