How to Shuffle the data at ROW level.

A

Anil Reddy

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.
 
L

Lori

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

Anil Reddy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Relevant user should see only his data 0
Macro to select and delete levels of a document 2
Sorting with expanding a section feature 1
Random Names and Command Button 1
combining two rows of data into one (Not Concatenate) 1
How can I change a date to UK format without shuffling the actual 3
Need a macro to combine the data from sheets 3
Creating Multi Level list using Header Style 1

Top