like to have my computer pick 6 number from my list

[jladika]

hello

I have a list of numbers and I would like my computer to pick 6 of them at ramdom.

I would think excel would me the program for this not sure.

for now just pick 25 numbers from 1 to 59 . Please if you will right this for me please send to me and remember I am very new to this

so send it just the way i need to put it in my computer.

thanks

[ɹəuəllıʍ ʇɐb]

Use a scripting language [e.g. VBScript] that has a 'random' function [usually rnd()], then write the appropriate script to pick your numbers randomly. You can download the documentation from here.

[y2khardtop]

from excel 2000 help file

RAND

See Also

Returns an evenly distributed random number greater than or equal to 0 and less than 1. A new random number is returned every time the worksheet is calculated.

Syntax

RAND( )

Remarks

To generate a random real number between a and b, use:

RAND()*(b-a)+a

If you want to use RAND to generate a random number but don't want the numbers to change every time the cell is calculated, you can enter =RAND() in the formula bar, and then press F9 to change the formula to a random number.

Examples

To generate a random number greater than or equal to 0 but less than 100:

RAND()*100