I stand corrected
Lance
-----Original Message-----
Just a head's up, but
This formula will try to do [a little less than 1% of
the time. ]

=INDEX($G$1:$G$100,0) which will result in an error
value rather than
returning a date

Regards,
Tom Ogilvy


Lance wrote in message
...
in column b enter
=INDEX($G$1:$G$100,ROUND(RAND()*100,0))

Lance
-----Original Message-----
I have ColumnA with values in 11,000+ rows. In
ColumnG I
have 100 dates. How can
I randomly distribute those 100 dates in ColumnB so
that
ColumnB has one of the
100 dates for each of the rows in ColumnA? In other
words, I want a
corresponding date in ColumnB for each row in ColumnA.

Thanks!

Steve


.



.