Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to randomly assign numbers to names?
I need to have numbers randomly assinged to names. The numbers will all be 5
digits. I was told that excel can do this but I can't seem to figure it out. Please help!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to randomly assign numbers to names?
Say your list of names was in A1 to A100.
Enter this formula in B1: =INT(RAND()*(99999+1-10000)+10000) And copy down to B100. Then, you can turn *off* auto calc by: <Tools <Options <Calculation tab, And click on "Manual" Now, every time you hit <F9, you'll get a new set of random numbers next to your list of names. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Empress" wrote in message ... I need to have numbers randomly assinged to names. The numbers will all be 5 digits. I was told that excel can do this but I can't seem to figure it out. Please help!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to randomly assign numbers to names?
I forgot to mention, I could have posted this formula:
=INT(RAND()*(90000)+10000) BUT, I left the formula in an uncalculated form so that you could change the parameters yourself if you wished. 99,999 is the top limit of number to return, while 10,000 is the bottom limit. This follows your request for a 5 digit number. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ragdyer" wrote in message ... Say your list of names was in A1 to A100. Enter this formula in B1: =INT(RAND()*(99999+1-10000)+10000) And copy down to B100. Then, you can turn *off* auto calc by: <Tools <Options <Calculation tab, And click on "Manual" Now, every time you hit <F9, you'll get a new set of random numbers next to your list of names. -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Empress" wrote in message ... I need to have numbers randomly assinged to names. The numbers will all be 5 digits. I was told that excel can do this but I can't seem to figure it out. Please help!!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to randomly assign numbers to names?
Hi Empress,
You can also use =RANDBETWEEN(10000,99999) If RANDBETWEEN is not available you will need to run the Analysis Tool Pack add-in. HTH Martin |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to randomly assign numbers to names?
P.S. Does that shorten things up RD <vbg
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to randomly assign numbers to names?
Actually, I'm not too sure.
*Don't* have to enable the ATP when using Rand(), but you do if you're using RandBetween().<g -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "MartinW" wrote in message ... P.S. Does that shorten things up RD <vbg |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to randomly assign numbers to names?
Yeah! That's true RD,
On face value it does appear to be shorter, 2 functions and 2 calculations versus 1 function plus the enabling of the ATP. To my mind it should be shorter, but seeng as how my thoughts are based on nothing more than gut feeling, they don't have much real value. So does anyone actually know the answer? Does enabling the ATP use more resources than just hard-drive space? I guess what I'm asking is does Excel have to go down the street, round the corner and into another building to access the ATP, or can it access the ATP on a direct line without having to leave it's own desk. Regards Martin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
assign numbers a value, then get percentage | Excel Worksheet Functions | |||
Why are column names in numbers instead of characters? | Excel Discussion (Misc queries) | |||
fitting route numbers to drivers names | Excel Worksheet Functions | |||
how can i assign i set of numbers (1-16) without repeating them? | Excel Worksheet Functions |