Thread: Formula for number combinations.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default Formula for number combinations.
Hello,

Select 6 adjacent cells horizontally and array-enter:
={2,4,6,8,10,12}-INT(RAND()*2)

Regards,
Bernd
Reply With QuoteReply With Quote