| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Can the computer be set to randomly select a row for a drawing?
I will be entering in a whole list of names from various locations for a
drawing. How can I ramdomly select a registered winner? |
|
#2
|
|||
|
|||
|
lets say your list of names is in row A1:A100. You could type a formula in
B1 that says =RANDBETWEEN(1,100) keep in mind that the result will change every time you open the file, press F9 and probably a few other circumstances. So, if you want to save the result, you'll need to copy/paste values over top of the formula after it picks the winner. "annie33" wrote: I will be entering in a whole list of names from various locations for a drawing. How can I ramdomly select a registered winner |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Win98 SE, Office 2000: ODBC from Excel behaves strangely on one computer | Excel Discussion (Misc queries) | |||
| Computer freezes while using mouse to select group of data in Exce | Excel Discussion (Misc queries) | |||
| In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
| Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions | |||
| Autocomplete works with my home computer but not the office computer | Excel Discussion (Misc queries) | |||
Hybrid Mode
