Forum Discussion
Random value in table with fixed proportion/ratio
Hi, I am making a pivot table aka database in excel. I have a column to fill in randomly with the values "Yes" or "No". I do know how to fill in random values, however I need a fixed proportion/r...
Hi brooij_bdr
If you want a solution of your requirement using excel functions, you can use attached file that will always generate desired proportion of 'Yes/No' in different positions.
Thanks
Tauqeer