Random sorting, shuffling and selecting data in Microsoft Excel

Random Sorter for Microsoft^® Excel^®

Random selection in Excel, shuffle cells, columns, rows at random

For Microsoft Excel 2010 32-bit and 64-bit, Excel 2007, Excel 2003.

Random Sorter for Excel can help you with two kinds of tasks: shuffling / sorting randomly data in your worksheets and doing a random selection.

Need to do one of these tasks in Excel?

Shuffling /Random sorting

• Shuffle rows or columns in your worksheet at random.
• Mix cells within selected columns, rows or a range.
• Get a random sample of a specified size from a set of your data.
• Randomly select the needed number or percentage of rows, columns or cells from your Excel list.

If you need to perform at least one of the above mentioned tasks, then you have found the right tool - Random Sorter for Excel.

The add-in is neatly embedded into your worksheets as a task pane and works for all versions of Microsoft Excel, from 2000 to 2010 (32-bit and 64-bit).

Random Sorter will help you with such challenges as:

• Generating random draws or pairs for a competition
• Picking a random number of names or telephone numbers from an Excel spreadsheet on a percentage basis
• Making a random permutation of sequential numbers
• Choosing a random lottery winner or winners

As you understand, the above list is far from being complete. These are just a few examples of various highly specific tasks that our Random Sorter can help you with. All those jobs, however easy they may seem, just cannot be done by yourself. Otherwise, how can you be sure that the results are really random? :) The Random Sorter for Excel is absolutely unbiased and very quick! Even if you have a huge Excel workbook, the add-in will do the job in a snap. You just select a range, choose the action - to shuffle or to select - and enjoy the results!

Shuffle cells, columns, rows

The Suffle (sort randomly) option hardly needs any explanations. As you see in the screenshot, the Random Sorter add-in can mix values in rows, columns or in a selected range, and put them in a random order.

You simply choose how exactly you want to shuffle your data in Excel and click Suffle. The add-in can sort randomly:

• Cells in each row
• Cells in each column
• Entire rows
• Entire columns
• All cells in a selected range

If your table has headers, don't forget to tick the Exclude header rows checkbox. For more details see How to randomly sort cells in rows, columns and a range.

Random selection

Using this option you can instantly get a random selection from a set of your Excel data. Imagine that you have a long list of names and you want to randomly select a certain number from the list. It takes no more than just a few seconds with our Random Sorter for Excel.

You specify whether you want to pick individual cells, entire rows or columns and decide if you want to select:

• Percentage of data
• Exact number of rows, columns or cells

Click the Select button and voila, here you go! Find step-by-step instructions here: How to select random data in Excel.

All is very easy, isn't it? To make sure, just download the Random Sorter for Microsoft Excel now and see for yourself!

Download now and see how it can help you