Thread: Random numbers of 1-9 using only 4 numbers in each column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey Duke Carey is offline
external usenet poster
  
Posts: 1,081
Default Random numbers of 1-9 using only 4 numbers in each column
Use Index() with Randbetween()


"Janet" wrote:

I have divided 36 numbers (1-9) into groups of 4. I need to randomly pick 1
number from each group. How do I do that?
Reply With QuoteReply With Quote