aghaffar82
Board Regular
- Joined
- Jun 13, 2019
- Messages
- 65
- Office Version
- 365
- Platform
- Windows
Hello, I have two values i.e. "red" & "blue" and I want to list (100 entries) them randomly and also want to make sure that they show only a certain percentage inserted in cell E2. The cell E1 would be either red or blue. For example, if % entered in cell E2 is 75% and value in cell E1 is red, it should list randomly (red, red, blue, red.....) 75 times "red" and 25 times "blue" in the cells A3:A102.
Thank you and looking forward to your kind help. Best Regards
Thank you and looking forward to your kind help. Best Regards