What I want to do is this: I have a many cells scattered throughout many worksheets. I want to take these cells and put them in one long list. But I want the cells to be in a random order. I could with some work just copy all these cells onto the list, but I want to make it in a random order. I want it to work like sort ascending button, except instead of creating order, making it disorganized.
I may need to add more info to describe what I want to do.
Not sure if this is what you're looking for, but here goes...
If cell G5=Dog, H19=Cat, L4=Fish, AA42=Hamster...
Wherever your list is located, add a column before it, for this example I'll use column A to start, with my list in column B.
In column A, rows 1-4, enter the formula: =RAND()
In column B, enter formula references to the cells containing your data
in this case,
in B1 enter: =$G$5
in B2 enter: =$H$19
in B3 enter: =$L$4
in B4 enter: =$AA$42
(The $'s are so that when you sort, the cells are referenced statically, not relatively.)
Select columns A and B, then click the A->Z (sorting) button. Each time you click that button, the list will resort randomly. This is because the "RAND()" values in column A are volatile - meaning they change every time the sheet recalculates. With only 4 entries, the list can and will repeat the same order often (even with randomness). In a longer list it will appear much more random.
If that's not what you're looking for please try to explain in more detail.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
zuri125 
Register To Reply
Bookmarks