Thread: Selecting random subset of values from one column into another
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karenne Karenne is offline
external usenet poster
  
Posts: 1
Default Selecting random subset of values from one column into another
Hi. Hoping that someone can help me with this query.....

I have a column with 100 values. I would like to create another column with
30 values selected randomly from the 1st column of 100 values. Is there a
formula i can use to do this?

Thanks!

Karenne Tun
Reply With QuoteReply With Quote