Latest Lists

I need to randomize column A in Excel. How do I do it?

I need to be able to refresh a list, and have the random results differ each time. I really only need the list to go up to A60, but it might be easier to just randomize the entire column. Please help! I have asked this question before, but I have never been able to articulate what it is I actually need. I know Excel can do it, I just do not know how to tell it what to do. What I need is 60 cells, each with a different "value or text" in them to be mixed into random order. Imagine it like shuffling a deck of cards. There might be four "2's" and four "queens" etc, all the way to sixty cards. Then I need to be able to change the names of the cards, and "re-shuffle" as often as I need. There cannot be any duplicate values returned, unless I wrote the same value multiple times on the list; in which case if I wrote the same value three times, then there would be three in the shuffled results respectively. If this is something you can help with. Please email me at bhowe@cfl-usa.com Thanks!

Public Comments

1. One of the simplest ways is to create a new column and use =rand() in it. Copy the formula to the rest of the column by double clicking on the fill handle in the bottom right of the cell (where the cursor turns into a thick +). Then sort on that column. To recalculate the numbers go to the formulas ribbon and hit "Calculate Now" on the far right or press Shift + F9 then resort.
2. This answer will autosort list and will also leave original list in the order you entered it Col A is data, in B1 enter =RAND() In C1 =INDEX (A:A,MATCH (SMALL(B:B,ROWS($1:1)), B:B,0)) Copy B1 & C1 down to match col A