Remember Me?

#1
February 15th 05, 05:59 PM
 tjb Posts: n/a
random selection from a range of cells

I'm making a prize drawing list.

I have a list of about 8500 numbers, some of which are duplicated, which is
OK, I want multiple entries to increase chance of winning. How can I return
a random number at will from this range of cells?

#2
February 15th 05, 06:34 PM
 Bernie Deitrick Posts: n/a

tjb,

Each time you recalc (Ctrl-Alt-F9), this will return a random value from
column A, no matter how many values you have in column A. Note that you
cannot have any blanks within your list, and your list must start in cell
A1.

=INDEX(A:A,ROUND(RAND()*COUNTA(A:A),0))

HTH,
Bernie
MS Excel MVP

"tjb" wrote in message
...
I'm making a prize drawing list.

I have a list of about 8500 numbers, some of which are duplicated, which

is
OK, I want multiple entries to increase chance of winning. How can I

return
a random number at will from this range of cells?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Sukismomma Excel Worksheet Functions 5 January 27th 05 02:34 AM tim Excel Worksheet Functions 2 January 12th 05 09:10 PM Scott Steele Excel Worksheet Functions 6 December 17th 04 03:23 AM Cgbilliar Excel Worksheet Functions 2 November 3rd 04 10:42 PM K.S.Warrier Excel Worksheet Functions 2 November 2nd 04 08:24 AM

All times are GMT +1. The time now is 09:51 AM.