I tried the formula you provided, and verified I had entered it correctly.
When I enter the number I want to investigate in the final step (number
entered in a16), it only works with the #1 (the row shows "1x1"), but not for
other numbers.

In the first line of your instruction below, you say "copy to the right,
ending in M1." I'm assuming you intended to say "M2" (the copy wont go to M1)

T.S.

"Niek Otten" wrote:

Here's one way. Certainly not the most clever one, but it demonstrates what's going on and can easily be extended beyond 12.

In B1, enter 1. In C2, enter =B1+1. Copy to the right, ending in M1.
In A2, enter 1. In A3, enter =A2+1. Copy down, ending in A13.
In B2, enter =$A2*B$1
Copy down, ending in B13
Copy B2:B13 to the right, ending in column M

In B15, enter =(MATCH($A$16,B2:B13,0))
Copy to the right, ending in M15. You'll see a few #NAs, don't bother.
IN B16, enter =IF(ISNA(B15),"",IF(B15B$1,"",B15&" * "&B$1))
Copy to the right, ending in M16.

Enter the number you want to investigate in A16. Row 16 will show you the multiples

You can hide row 15 if you dislike it, or you can skip this intermediate step. That requires longer formulas.
Post again in this thread if you can't get it done.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel



"Excel Novice" wrote in message ...
| How do you use excel to calculate multiples of a number? I am creating a
| multiplication table for my dtr. up to 12. Can I create the table in Excel
| and overlay a function that would calculate the multiples for each number in
| the table? Example: "24" (multiples a 24x1; 12x2; 6x4 and 4x3)
|
| T. Scott