View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve[_27_] Steve[_27_] is offline
external usenet poster
 
Posts: 15
Default Randomly fill in rows

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