Shuffle and select a random sample of cells, rows or columns
Random Sorter for Microsoft Excel 2016, 2013-2003
You need to shuffle the Excel list of your employees to specify the order of people who will be on duty. Or need to pick 25 random lucky customers who will get a discount.
Random Sorter for Microsoft Excel will help you in either case. This randomizing device makes shuffling data and random selection easy, concise and unbiased.
Random Sorter for Excel key features
- Shuffle your Excel data
- Randomly sort cells in each row or column
- Mix entire rows or entire columns at random
- Randomly sort all cells in a range
- Get a random sample in Excel, i.e. the needed number or percentage of rows, columns or cells
You can get this add-in as a part of Ultimate Suite for Excel - 40+ tools destined to cut your time and clicks on the most frequent spreadsheet tasks.
How Random Sorter works
It may be a hassle to pick a hundred lucky winners from 1,000,000 participants, or 25% of your customers for taking part in the poll. Random Sorter add-in for Excel makes the whole thing fast and fair.
This Excel add-in is equally good at shuffling and random selection. The really random sorting mechanism can easily process the entire worksheet or selected entries.
So whenever you need to mix up some data or get a random sample of rows, columns or cells, you simply define the range, set the parameters and click Shuffle or Select.
Shuffle your Excel data
Shuffling values in your Excel spreadsheet doesn't seem to be a really difficult task. But if you try to do it manually, it can take hours and hours of your precious time. Random Sorter automates this task allowing you to spend the time on some more productive work. It is possible to randomly sort rows, columns or cells in the entire table or selected range in less than a few seconds.
Randomly sort cells in each row or column or mix entire rows or columns
The add-in's enhanced sorting options enable you to shuffle values in each row or column without intermixing them. Or, you can choose to shuffle rows or columns leaving the data within them as they are.
Mix all cells in the selected cell area at random
Suppose you have a column with names sorted alphabetically. The next column contains some numerical data so that each name has a number assigned. You would like to randomly sort the numbers without changing the order of the names. No problem! This Excel plug-in allows shuffling data within a selected range to leave other values as they are. In addition, it is possible to sort data in several selected ranges at the same time.
Select a random sample in Excel: a definite number or percentage of rows, columns or cells
With the Random Sorter add-in you can get a random sample of any entries in the worksheet - cells, columns or rows. You can also customize the selection by setting the number or percentage of occasional cell, row or column values. It may be especially helpful if you have fixed lists, need to get their data at random but don't want to change the table.
Random Sorter for Microsoft Excel system requirements
- Microsoft Excel 2016 (32 and 64-bit)
- Microsoft Excel 2013 (32 and 64-bit)
- Microsoft Excel 2010 (32 and 64-bit)
- Microsoft Excel 2007
- Windows 10 (32 and 64-bit)
- Windows 8 (32 and 64-bit)
- Windows 7 (32 and 64-bit)
- Windows Vista (32 and 64-bit)
- Windows XP (32-bit)
- Windows Server 2003, 2008, 2012
- .NET Framework 4.0 must be installed.
Random Sorter for Excel version
Current add-in version: 3.0.22
published on: Feb 02, 2016