![]() |
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.
|
create a column and fill each cell with a random number, sort on that column
|
Ahhhh. Thanks man, I'm a dumbass. This is so labor intensive I did not even think of that. Thanks..
|
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. :) |
All times are GMT -4. The time now is 01:15 PM. |
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
© Greenguy Marketing Inc