Drawing program

phillip

July 06, 2007 19:06

Who was offering the program that drew the winners name?

0

• 

  spurgemastur

  July 06, 2007 19:46

  quote:Originally posted by phillip
  Who was offering the program that drew the winners name?
  
  
  I don't remember but if you type the entrants names into column A in an Excel spreadsheet and then copy and paste the following formula into any cell NOT IN COLUMN A, it'll draw a winner at random:
  
  =INDEX(A:A,TRUNC(RAND()*COUNTA(A:A)+1))

  0
• 

  phillip

  July 07, 2007 19:18

  quote:Originally posted by spurgemastur
  quote:Originally posted by phillip
  Who was offering the program that drew the winners name?
  
  
  I don't remember but if you type the entrants names into column A in an Excel spreadsheet and then copy and paste the following formula into any cell NOT IN COLUMN A, it'll draw a winner at random:
  
  =INDEX(A:A,TRUNC(RAND()*COUNTA(A:A)+1))
  
  
  thanks

  0

Please sign in to leave a comment.