Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I want to sort data randomly in addition to the current descendin.
That's basically it. I have existing worksheets of data that I would like to
sort in random order. There are roundabout ways to do this with formulas, but this can be tricky, and does not work in all situations. |
#2
|
|||
|
|||
Can you really call putting data in a random order Sorting?
tj "ckephart" wrote: That's basically it. I have existing worksheets of data that I would like to sort in random order. There are roundabout ways to do this with formulas, but this can be tricky, and does not work in all situations. |
#3
|
|||
|
|||
Hi
the solution I know would invole a helper column with the formula =RAND() for all rows and sorting with this helper column. This should work -- Regards Frank Kabel Frankfurt, Germany "ckephart" schrieb im Newsbeitrag ... That's basically it. I have existing worksheets of data that I would like to sort in random order. There are roundabout ways to do this with formulas, but this can be tricky, and does not work in all situations. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
Data > Sort function amnesia? | Excel Discussion (Misc queries) | |||
cells lose relativity to other WorkSheets after data sort? | Excel Worksheet Functions |