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

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


.

in B1 put the formula

=Index($G$1:$G$100,trunc(rand()*100+1),1)

Drag fill down the column for 11000+ rows.

then select column B and do Edit=Copy, then Immediately Edit=PasteSpecial
and select values.

Regards,
Tom Ogilvy

Steve wrote in message
hlink.net...
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

Tom,

Thanks for the help!!

Steve


"Tom Ogilvy" wrote in message
...
in B1 put the formula

=Index($G$1:$G$100,trunc(rand()*100+1),1)

Drag fill down the column for 11000+ rows.

then select column B and do Edit=Copy, then Immediately Edit=PasteSpecial
and select values.

Regards,
Tom Ogilvy

Steve wrote in message
hlink.net...
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