Comments Order Scramble
- Thread starter aznxmtg
- Start date
Disposable
Registered Member
- Apr 15, 2009
- 65
- 60
Use Excel.
1) Open the file making sure that each comment is on a separate line.
2) In the column next to the comments insert "=rand()". Fill down to the end of the comments. This generates a random number for each comment.
3) Highlight the range that includes the comments and the random number columns. Sort on the random number.
4) Copy the comments and paste into a new text file.
5) Save the new randomized comment file.
Voila! You have a randomly sorted comment file in under 60 seconds.
1) Open the file making sure that each comment is on a separate line.
2) In the column next to the comments insert "=rand()". Fill down to the end of the comments. This generates a random number for each comment.
3) Highlight the range that includes the comments and the random number columns. Sort on the random number.
4) Copy the comments and paste into a new text file.
5) Save the new randomized comment file.
Voila! You have a randomly sorted comment file in under 60 seconds.
Disposable
Registered Member
- Apr 15, 2009
- 65
- 60
Thanks just learn something new for excel
You are very welcome!