How to Shuffle the data at ROW level.
 

Hi All

This is anil. can any please answer that how to shuffle the data at ROW
level. Pls let me know if there is any feasibility to shuffle the data in
excel.
--
Thanx & Regards
Anil Reddy,
India,
+919247108156.

How to Shuffle the data at ROW level.
 

Add a column next to your data of random numbers with "=rand()". Then
sort by this column.


On 12 Mar, 13:11, Anil Reddy
wrote:
Hi All

This is anil. can any please answer that how to shuffle the data at ROW
level. Pls let me know if there is any feasibility to shuffle the data in
excel.
--
Thanx & Regards
Anil Reddy,
India,
+919247108156.

How to Shuffle the data at ROW level.
 

Hi Lori

Thanx for responding to my query. As per ur logic i done this
earlier only. This will work out but the random number will not generate the
unique numbers some times it will generate duplication of numbers. Due to
this the shuffleing may not happen properly.

Is there any other aletrnative way to do.
--
Thanx & Regards
Anil Reddy,
India,
+919247108156.


"Lori" wrote:

Add a column next to your data of random numbers with "=rand()". Then
sort by this column.


On 12 Mar, 13:11, Anil Reddy
wrote:
Hi All

This is anil. can any please answer that how to shuffle the data at ROW
level. Pls let me know if there is any feasibility to shuffle the data in
excel.
--
Thanx & Regards
Anil Reddy,
India,
+919247108156.