Excel: About Random number generator function

Hi All, I have Columns as A B C D E 1 Age(18-24) Age(25-34) Age(35-44) Age(45-54) Age(55-Above) 2 I want random number generated in all the columnin 2[SUP]nd[/SUP] row i.e. A,B,C,D,E such that whose sum(A+B+C+D+E) will be 100 thanks in advance.

This question generated 25 answers. To proceed to the answers, click here.

This thread is current as of July 24, 2014.

For more resources for Microsoft Excel