I am ultimately trying to copy rows out of Excel to another Excel list. For example, if there are 100 records in the Excel listing, I will select 5 at random. The catch: each of the 100 records needs an equal chance of being selected - so the random number generator must range from 1 - X number of rows in Excel list.
I want to create an array of random, unique numbers based on the size of the population and then use those numbers as an index when selecting the rows to copy out of Excel.
Anyone have a solution to accomplish this?