Tuesday, March 31, 2009

Excel: Placing the given values in Randomly

1. Enter the number of values in the Column A in rows [A1 to A10].
2. In Column B add random number by inserting the formula =Rand () in
each row up to Column A values [B1 to B10].
3. Select the Both Column
4. In Menu Bar, go to Data>Sort.
5. Sort by Column B, where by the random numbers

You will get the random series values from A1 to A10 in Excel

No comments:

Adobe News