JDMCQ's Garage

uh oh, Lisa's wooting again.

 

http://lmgtfy.com/?q=excel+random+number+generator

first link

 

Nope that aint it, i need to use the random number generator that is in the data analysis toolpak. My problem is that i cant figure out to make it do just integers. It does decimals which doesnt work for lottery numbers that im trying to generate

 

can you take the decimals and multiply by 100 (or what ever it is to get a whole number)

 

I just played with it in excel. Can you use Excel to round off the numbers once you generate them?

 

there is a way to generate whole numbers i just dont know how, ive seen the professor do it before. dont remember tho

 

i didn't see how to do that. I was able to generate the numbers, round it off, then i copied just the values to another column.

 

i need 56 variables to have a total of 3370 results which is way too many values to edit, theres a way of doing it. SO the results should be 1,5,56,34,40, etc 3370 times

 

that is what i got, but i have to do minor tweaking after it generated the numbers.

 

so how is yours set up

 

i did the random number generator as part of the data analysis toolpak.

number of variables: 0
Number of random numbers: 3370
Uniform number selection
parameters between 1 and 56
output to a new work book.

the first column will have 3370 numbers betwen 1 and 56. in b2 i put =ROUND(A1,0) which will round to the nearest whole number. I then copied it to the rest of that column. then i copied that column and did a special past to the next column and selected values to have only the values listed not the formula.

 

what's so bad about curved walls? your just drawing them.

 

formatting the column doesn't change the underlying value. i tried that first. If you are going to use the numbers for some other calculations, then it would give you skewed results.

 

that worked, now i just need to count the times the times each variable occurs... any help with that formula. Seems like is should be just a count function but im having no luck. So im looking for a forumla that =(1,A1:A3370) and gives me a total. i would do that 56 times

 

got the countif funciton working, thanks everyone ill be back probably