Random Date Generation
In column A list all the dates between 1/1/05 and 10/31/05
In cell B1 enter:
=RAND() and copy down
Sort both columns by column B. This will randomize the data in column A.
Just copy out the first 15 items in column A
To get a different 15, pump F9 and resort.
--
Gary's Student
"TNMAN" wrote:
Could someone please help me generate a list of 15 random dates between
1/1/05 and 10/31/05 without any duplicates? Thanks in advance for all your
help.
Frustrated in Tennessee
|