 |
|
|
|
|
|
|
|
|
2006-04-27, 10:41 AM
|
#1 |
|
Registered User
Join Date: Apr 2005
Location: Central Jersey! If I was rich and powerful I would dress as my avatar does.
Posts: 1,448
 |
Anyone know excel?
I'm trying to randomize my rows. I have downloaded all my sponsers links and sorted them by cats. But my problem is I don't want to have, say the first 100 links in my cats go to one sponser. Anyone know how to randomize the rows for excel? Im looking around and all I'm finding is random number generation.
|
|
|
|
2006-04-27, 10:49 AM
|
#2 |
|
a.k.a. Sparky
Join Date: Sep 2004
Location: West Palm Beach, FL, USA
Posts: 2,396
|
create a column and fill each cell with a random number, sort on that column
__________________
SnapReplay.com a different way to share photos - iPhone & Android |
|
|
|
|
2006-04-27, 10:54 AM
|
#3 |
|
Registered User
Join Date: Apr 2005
Location: Central Jersey! If I was rich and powerful I would dress as my avatar does.
Posts: 1,448
|
Ahhhh. Thanks man, I'm a dumbass. This is so labor intensive I did not even think of that. Thanks..
|
|
|
|
|
2006-04-27, 11:33 AM
|
#4 |
|
That which does not kill us, will try, try again.
Join Date: Aug 2003
Location: Conch Republic
Posts: 5,150
  |
One more nice thing about doing it that way...
The RAND function in Excel will give you a new sort each time you ask for it. Insert the function, fill down, select the area for sorting and sort. Now look at the new list. Don't like the 'randomness' enough yet? If you haven't deselected the sorted area, just choose "Sort..." again and you get a fresh reordering. Repeat until you like your list. 
__________________
"If you're happy and you know it, think again." -- Guru Pitka |
|
|
|
 |
|
|
Linear Mode
