ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Random Sort (https://www.excelbanter.com/excel-discussion-misc-queries/258917-random-sort.html)

Dennis Tucker

Random Sort
 
There are times when I want to mix up a table order-wise. It would be a nice feature for Excel to have a sort method that would randomize the record set in a table.

What do you guys think about this?


James Silverton[_3_]

Random Sort
 
Dennis wrote on Mon, 15 Mar 2010 07:41:48 -0700:

There are times when I want to mix up a table order-wise. It
would be a nice feature for Excel to have a sort method that
would randomize the record set in a table.


What do you guys think about this?


Would not sorting on a helper column of random numbers not achieve what
you want?

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not


Dennis Tucker

Random Sort
 
Yes. But I think it would be sweet if Excel offered this feature instead of
building a column of random numbers then sorting the table by that column.



"James Silverton" wrote in message
...
Dennis wrote on Mon, 15 Mar 2010 07:41:48 -0700:

There are times when I want to mix up a table order-wise. It
would be a nice feature for Excel to have a sort method that
would randomize the record set in a table.


What do you guys think about this?


Would not sorting on a helper column of random numbers not achieve what
you want?

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not




All times are GMT +1. The time now is 01:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com