View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jack Sons Jack Sons is offline
external usenet poster
 
Posts: 144
Default random 3 out of many

Hi all,

In column A I have in each cell one alfphanumerical item, the lenghts
differ.
In column B should get in each cell, from B1 down, 3 randomly picked items
of column A (format: item, item, item) without any duplicates (each A-item
only once in B).
Column A could contain a few hundred items, so a macro would be handy, but I
can't figure out how.
Your help will be appreciated.

Jack Sons
The Netherlands