Most valuable professional
  • Hot Topics

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 2nd row i.e. A,B,C,D,E such that whose sum(A+B+C+D+E) will be 100 thanks in advance. Last edited by Ashwini Lambture; Jul 24th, 2014 at 07:39 AM.

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:

This article includes the following tags:

  • Excel
  • Microsoft Excel