Remember Me?

Menu

#1
February 15th 05, 06: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, 07: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?

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 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 03:34 AM tim Excel Worksheet Functions 2 January 12th 05 10:10 PM Scott Steele Excel Worksheet Functions 6 December 17th 04 04:23 AM Cgbilliar Excel Worksheet Functions 2 November 3rd 04 11:42 PM K.S.Warrier Excel Worksheet Functions 2 November 2nd 04 09:24 AM

All times are GMT +1. The time now is 03:52 PM.

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

About Us

"It's about Microsoft Excel"

Copyright © 2017