Originally Posted by
ChemistB
A little tricky because if each cell is totally random, then you might not have enough dates between present cell and date and final cell and date.
Here's a possibility
In E5 dragged down 1/1/2012 through 11/1/2012 (All of this can be hidden afterwards or placed on a different sheet)
In D5 dragged down just as far, =RAND()
Copy and paste special >values to make the random numbers constant. Then sort on the random numbers
In A5 dragged down
=SMALL($E$5:$E$198, ROW(A1))
If you want it to begin and end with 1/1 and 11/1, just fill in A5 and A198 manually.
Does that work for you?
Bookmarks