Hi,
I have a population of items (for e.g 20 items) which I want to select 5 samples of (without repeating).
For eg, I have the following items:
1. apple
2. apple
3. banana
4. banana
5. orange
6. apple
7. pear
8. mango
9. orange
10. apple
11. pear
12. apple
13. banana
14. grape
15. durian
16. papaya
17. grape
18. apple
19. pineapple
20. starfruit
I would like to randomly choose a sample of 5 fruits without repeating from the list above (for e.g apple, starfruit, pineapple, orange, mango). What formulas or macros will be able to help me in the excel?
Thanks
Bookmarks