I wish to run a random sample of 60 numbers from a population of 75 numbers
without repeating any number more than once. The data analysis - sampling
tool generates the 60 random numbers but duplicates several numbers.
I wish to run a random sample of 60 numbers from a population of 75 numbers
without repeating any number more than once. The data analysis - sampling
tool generates the 60 random numbers but duplicates several numbers.
See
http://www.mcgimpsey.com/excel/udfs/...noreplace.html
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Max55" <Max55@discussions.microsoft.com> wrote in message news:BAFB37DE-8F7B-4EE2-A41F-92F1A0B1DE0B@microsoft.com...
|I wish to run a random sample of 60 numbers from a population of 75 numbers
| without repeating any number more than once. The data analysis - sampling
| tool generates the 60 random numbers but duplicates several numbers.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks