Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I shuffle a group of cells randomly in Excel?
|
#2
|
|||
|
|||
generally this is achieved via the use of a "helper"column - another column
adjacent to what you want to sort where you type in a function to generate random numbers (e.g. =ROUND(RAND()*100,0) ) and then you change this column from a formula to values (copy it, select it again - edit / paste special - values) and then you sort of this column to get a "random" sort. The column can be deleted once you've sorted. Cheers JulieD "golfmoab" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) | |||
Adding contents of cells by clicking in Excel 2002 | Excel Discussion (Misc queries) | |||
Excel: To Display Formula in the cells Instead of Value | Excel Discussion (Misc queries) | |||
linking cells in Excel 2003. How to not truncate to 255 characters. | Excel Discussion (Misc queries) |