close

How do I randomize rows in Excel?

In an empty column, enter

=RAND()

and copy down as far as you need to go. Then, sort by that
column.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
quot;Jayyyyyyquot; gt; wrote in message
...
gt; How do I randomize rows in Excel?
For a more dynamic approach, get the free addin PopTools.
HTH
Dave Braden

quot;Jayyyyyyquot; gt; wrote in message
...
gt; How do I randomize rows in Excel?

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄