I'm looking for an Excel Program (not using Macros) on how to create a Number Generator. For example I have 2 sets of 3-digit numbers 387 and 025. What I want to do is plug those 2 (3-digit) sets in a Excel Formula and come up with 5 and only 5 new 3-digit sets like for example 984, 631, 095, 723, 442. So it could look like this
Midday Evening
387 025
and come up with 5 new (3-digit numbers) those numbers would appear
Here >
And repeat that from day to day
I use Excel 2003, daily for Sports stats, and other things.
How are your five numbers related to the original two?
from the previous 3-digit numbers drawn for Michigan's Feb. 22 Midday number was 444, and evening number was 567. So you would plug those 2 numbers Midday 444, Evening 567 in to get 5 new Numbers for the next day.
I use Excel 2003, daily for Sports stats, and other things.
=text(randbetween(0, 999), "000") and copy down five lines.
Random results are independent of prior results -- probably not what you wanted to hear.
That didn't do anything only got #NAME?
when I copy it down 5 lines
I use Excel 2003, daily for Sports stats, and other things.
It requires that you have the Analysis ToolPak add-in (Tools > Add-Ins ...). If you don't want to do that, then
=TEXT( INT(1000 * RAND()), "000")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks