software

I am developing a math lesson worksheet for my homeschool lessons. One way
it's working quite well is to use the solutions of problems to find a letter
code. I would like to have the following attributes:
1.) 26 randomly-generated math problems, each with a unique solution.
2.) Not write a bunch of VB code to do it. (I'm kinda burned out on that).

Is there an easy solution? If you would like to see what I have so far,
please request it and I'll e-mail it to you. There is no VB on it right now,
so you can open it with macros turned off.
--
Adios,
Clay Harryman

Clay,

What kind of math problems are you looking at creating?

You could use sets of formulas like this, to create a division problem in cell D1:
Cell A1 =ROUND(RAND()*12,0)
Cell B1 =ROUND(RAND()*12,0)
Cell C1 =A1*B1
Cell D1 = C1 amp; quot; / quot; amp;B1 amp;quot; = ?quot;

Each press of F9 will create a new division problem, selected from up to the 12 times tables.

HTH,
Bernie
MS Excel MVPquot;Claymanquot; gt; wrote in message
...
gt;I am developing a math lesson worksheet for my homeschool lessons. One way
gt; it's working quite well is to use the solutions of problems to find a letter
gt; code. I would like to have the following attributes:
gt; 1.) 26 randomly-generated math problems, each with a unique solution.
gt; 2.) Not write a bunch of VB code to do it. (I'm kinda burned out on that).
gt;
gt; Is there an easy solution? If you would like to see what I have so far,
gt; please request it and I'll e-mail it to you. There is no VB on it right now,
gt; so you can open it with macros turned off.
gt; --
gt; Adios,
gt; Clay Harryman

Clay,

If you aren't at the level that you're teaching that any number / 0 is undefined, then use this in
Cell B1

= 1 ROUND(RAND()*11,0)

HTH,
Bernie
MS Excel MVPquot;Bernie Deitrickquot; lt;deitbe @ consumer dot orggt; wrote in message
...
gt; Clay,
gt;
gt; What kind of math problems are you looking at creating?
gt;
gt; You could use sets of formulas like this, to create a division problem in cell D1:
gt; Cell A1 =ROUND(RAND()*12,0)
gt; Cell B1 =ROUND(RAND()*12,0)
gt; Cell C1 =A1*B1
gt; Cell D1 = C1 amp; quot; / quot; amp;B1 amp;quot; = ?quot;
gt;
gt; Each press of F9 will create a new division problem, selected from up to the 12 times tables.
gt;
gt; HTH,
gt; Bernie
gt; MS Excel MVP
gt;
gt;
gt; quot;Claymanquot; gt; wrote in message
gt; ...
gt;gt;I am developing a math lesson worksheet for my homeschool lessons. One way
gt;gt; it's working quite well is to use the solutions of problems to find a letter
gt;gt; code. I would like to have the following attributes:
gt;gt; 1.) 26 randomly-generated math problems, each with a unique solution.
gt;gt; 2.) Not write a bunch of VB code to do it. (I'm kinda burned out on that).
gt;gt;
gt;gt; Is there an easy solution? If you would like to see what I have so far,
gt;gt; please request it and I'll e-mail it to you. There is no VB on it right now,
gt;gt; so you can open it with macros turned off.
gt;gt; --
gt;gt; Adios,
gt;gt; Clay Harryman
gt;
gt;
Yeah, I've got that down. Actually, we're working only with add amp; subtract
right now. I've got random number generators (that will automagically put the
bigger number on top). But I want the solutions to be unique. The solutions
point to letters in the alphabet, to solve a riddle.
--
Adios,
Clay Harrymanquot;Bernie Deitrickquot; wrote:

gt;
gt; Clay,
gt;
gt; If you aren't at the level that you're teaching that any number / 0 is undefined, then use this in
gt; Cell B1
gt;
gt; = 1 ROUND(RAND()*11,0)
gt;
gt; HTH,
gt; Bernie
gt; MS Excel MVP
gt;
gt;
gt; quot;Bernie Deitrickquot; lt;deitbe @ consumer dot orggt; wrote in message
gt; ...
gt; gt; Clay,
gt; gt;
gt; gt; What kind of math problems are you looking at creating?
gt; gt;
gt; gt; You could use sets of formulas like this, to create a division problem in cell D1:
gt; gt; Cell A1 =ROUND(RAND()*12,0)
gt; gt; Cell B1 =ROUND(RAND()*12,0)
gt; gt; Cell C1 =A1*B1
gt; gt; Cell D1 = C1 amp; quot; / quot; amp;B1 amp;quot; = ?quot;
gt; gt;
gt; gt; Each press of F9 will create a new division problem, selected from up to the 12 times tables.
gt; gt;
gt; gt; HTH,
gt; gt; Bernie
gt; gt; MS Excel MVP
gt; gt;
gt; gt;
gt; gt; quot;Claymanquot; gt; wrote in message
gt; gt; ...
gt; gt;gt;I am developing a math lesson worksheet for my homeschool lessons. One way
gt; gt;gt; it's working quite well is to use the solutions of problems to find a letter
gt; gt;gt; code. I would like to have the following attributes:
gt; gt;gt; 1.) 26 randomly-generated math problems, each with a unique solution.
gt; gt;gt; 2.) Not write a bunch of VB code to do it. (I'm kinda burned out on that).
gt; gt;gt;
gt; gt;gt; Is there an easy solution? If you would like to see what I have so far,
gt; gt;gt; please request it and I'll e-mail it to you. There is no VB on it right now,
gt; gt;gt; so you can open it with macros turned off.
gt; gt;gt; --
gt; gt;gt; Adios,
gt; gt;gt; Clay Harryman
gt; gt;
gt; gt;
gt;
gt;
gt;

Thank you for the quick answer, though! That was much quicker than I
anticipated!
--
Adios,
Clay Harrymanquot;Bernie Deitrickquot; wrote:

gt;
gt; Clay,
gt;
gt; If you aren't at the level that you're teaching that any number / 0 is undefined, then use this in
gt; Cell B1
gt;
gt; = 1 ROUND(RAND()*11,0)
gt;
gt; HTH,
gt; Bernie
gt; MS Excel MVP
gt;
gt;
gt; quot;Bernie Deitrickquot; lt;deitbe @ consumer dot orggt; wrote in message
gt; ...
gt; gt; Clay,
gt; gt;
gt; gt; What kind of math problems are you looking at creating?
gt; gt;
gt; gt; You could use sets of formulas like this, to create a division problem in cell D1:
gt; gt; Cell A1 =ROUND(RAND()*12,0)
gt; gt; Cell B1 =ROUND(RAND()*12,0)
gt; gt; Cell C1 =A1*B1
gt; gt; Cell D1 = C1 amp; quot; / quot; amp;B1 amp;quot; = ?quot;
gt; gt;
gt; gt; Each press of F9 will create a new division problem, selected from up to the 12 times tables.
gt; gt;
gt; gt; HTH,
gt; gt; Bernie
gt; gt; MS Excel MVP
gt; gt;
gt; gt;
gt; gt; quot;Claymanquot; gt; wrote in message
gt; gt; ...
gt; gt;gt;I am developing a math lesson worksheet for my homeschool lessons. One way
gt; gt;gt; it's working quite well is to use the solutions of problems to find a letter
gt; gt;gt; code. I would like to have the following attributes:
gt; gt;gt; 1.) 26 randomly-generated math problems, each with a unique solution.
gt; gt;gt; 2.) Not write a bunch of VB code to do it. (I'm kinda burned out on that).
gt; gt;gt;
gt; gt;gt; Is there an easy solution? If you would like to see what I have so far,
gt; gt;gt; please request it and I'll e-mail it to you. There is no VB on it right now,
gt; gt;gt; so you can open it with macros turned off.
gt; gt;gt; --
gt; gt;gt; Adios,
gt; gt;gt; Clay Harryman
gt; gt;
gt; gt;
gt;
gt;
gt;

Clay,

OK, I think I understand now. I always liked those problems when my kids
were that age.

Anyway, try this:

Cells A1:A100 =ROUND(RAND()*100,0)
Cells B1:B100 =IF(COUNTIF($A$1:$A$100,A1)=1,quot;OKquot;,quot;Notquot;)
Array enter, using Ctrl-Shift-Enter, in Cells C1:C26:
=INDEX(A:A,LARGE(ROW($B$1:$B$100)*($B$1:$B$100=quot;OK quot;),ROW()))

Cells D126 A through Z
Cells E1:E26 =RAND()
Cells F1:F26 =INDEX($C$1:$C$26,RANK(E1,$E$1:$E$26))

When you press F9, you will get a unique list of 26 random numbers between 1
and 100 in cells F1:F26, each corresponding to a letter A through Z.

Modify the formulas in A1:A100 to change your range of numbers.

HTH,
Bernie
MS Excel MVPquot;Claymanquot; gt; wrote in message
...
gt; Yeah, I've got that down. Actually, we're working only with add amp; subtract
gt; right now. I've got random number generators (that will automagically put
gt; the
gt; bigger number on top). But I want the solutions to be unique. The
gt; solutions
gt; point to letters in the alphabet, to solve a riddle.
gt; --
gt; Adios,
gt; Clay Harryman
gt;
gt;
gt; quot;Bernie Deitrickquot; wrote:
gt;
gt;gt;
gt;gt; Clay,
gt;gt;
gt;gt; If you aren't at the level that you're teaching that any number / 0 is
gt;gt; undefined, then use this in
gt;gt; Cell B1
gt;gt;
gt;gt; = 1 ROUND(RAND()*11,0)
gt;gt;
gt;gt; HTH,
gt;gt; Bernie
gt;gt; MS Excel MVP
gt;gt;
gt;gt;
gt;gt; quot;Bernie Deitrickquot; lt;deitbe @ consumer dot orggt; wrote in message
gt;gt; ...
gt;gt; gt; Clay,
gt;gt; gt;
gt;gt; gt; What kind of math problems are you looking at creating?
gt;gt; gt;
gt;gt; gt; You could use sets of formulas like this, to create a division problem
gt;gt; gt; in cell D1:
gt;gt; gt; Cell A1 =ROUND(RAND()*12,0)
gt;gt; gt; Cell B1 =ROUND(RAND()*12,0)
gt;gt; gt; Cell C1 =A1*B1
gt;gt; gt; Cell D1 = C1 amp; quot; / quot; amp;B1 amp;quot; = ?quot;
gt;gt; gt;
gt;gt; gt; Each press of F9 will create a new division problem, selected from up
gt;gt; gt; to the 12 times tables.
gt;gt; gt;
gt;gt; gt; HTH,
gt;gt; gt; Bernie
gt;gt; gt; MS Excel MVP
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; quot;Claymanquot; gt; wrote in message
gt;gt; gt; ...
gt;gt; gt;gt;I am developing a math lesson worksheet for my homeschool lessons. One
gt;gt; gt;gt;way
gt;gt; gt;gt; it's working quite well is to use the solutions of problems to find a
gt;gt; gt;gt; letter
gt;gt; gt;gt; code. I would like to have the following attributes:
gt;gt; gt;gt; 1.) 26 randomly-generated math problems, each with a unique solution.
gt;gt; gt;gt; 2.) Not write a bunch of VB code to do it. (I'm kinda burned out on
gt;gt; gt;gt; that).
gt;gt; gt;gt;
gt;gt; gt;gt; Is there an easy solution? If you would like to see what I have so
gt;gt; gt;gt; far,
gt;gt; gt;gt; please request it and I'll e-mail it to you. There is no VB on it
gt;gt; gt;gt; right now,
gt;gt; gt;gt; so you can open it with macros turned off.
gt;gt; gt;gt; --
gt;gt; gt;gt; Adios,
gt;gt; gt;gt; Clay Harryman
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;