How to have a list of text be sorted randomly?

P

PDG

I have 4 lists of titles of about 100 records each that I need to shuffle
each month for variety. Is there a function to sort this list of text records
randomly? I'm using Exel 2000.
 
T

tjtjjtjt

One way:
Create an extra column.
in the first cell, put this formula:
=Rand()
Copy it down to the end of your list.
sort by the new column.
Delete or hide it to get it out of your way.

tj
 
Top