ExcelBanter - randomize a list

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - randomize a list (https://www.excelbanter.com/excel-discussion-misc-queries/236739-randomize-list.html)

LelandKramer

randomize a list

what is thhe formula to randomize a list??

thank You
Shalom
Leland

Dave Peterson

randomize a list

I add a helper column filled with formulas (=rand())

Then I sort the entire range by that helper column.

LelandKramer wrote:

what is thhe formula to randomize a list??

thank You
Shalom
Leland

--

Dave Peterson

All times are GMT +1. The time now is 08:36 PM.