LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe Joe is offline
external usenet poster
 
Posts: 476
Default need to set up a formula to pick random numbers

i have a list of numbers and i would the computer to pick 6 of them .
1,2,3,5,6,13,16,17,18,20,21,22,23,25,26,27,28,32,3 4,35,36,40,42,44,46,47,48,50 and 50. this is for the lotto. each time i need to get 6 new numbers.
I have no back ground so please make this as easy as you can thank

Joe
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pick a Random name from a list. David M Fritzke Excel Discussion (Misc queries) 7 September 30th 08 05:11 PM
Random pick of a cell saman110 via OfficeKB.com Excel Discussion (Misc queries) 5 August 2nd 07 12:30 AM
Pick a Random name from a list. David M Fritzke Excel Worksheet Functions 5 August 25th 06 03:11 PM
random pick names from the list jinvictor Excel Discussion (Misc queries) 1 June 26th 06 03:00 PM
Can Excel pick random numbers from 1-300 and not repeat numbers? Julian Excel Discussion (Misc queries) 1 June 7th 06 07:17 AM


All times are GMT +1. The time now is 11:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"