52. Excel Tips - Random Sort in Excel
This tip shows you how to do a random sort of a list in Excel.
Suppose you have a list of people and you need a way to find out who goes first. Maybe you're the HR department of an investment bank and you need to decide quickly who to make redundant.
Here's a screen shot:
Here's the formula you would use:
.. you need to enter it as an array formula with the array the same size as the list.