Functin to calculate arguments for a product? (12= 12*1, 4*3, 6*2.
 

Functin to calculate arguments for a product? (12= 12*1, 4*3, 6*2.
 

Here's something you can play with:

A1 = 12

Enter this formula in B1 as an array using the key combination of
CTRL,SHIFT,ENTER (not just ENTER):

=SMALL(IF(MOD(A$1,ROW(INDIRECT("1:"&A$1)))=0,ROW(I NDIRECT("1:"&A$1))),ROWS($1:1))

Enter this formula in C1:

=A$1/B1

Select both B1 and C1 copy down until you get #NUM! errors.

Based on A1 = 12, the output will look like this:

..............B..............C
1...........1..............12
2...........2...............6
3...........3...............4
4...........4...............3
5...........6...............2
6..........12..............1
7......#NUM!.....#NUM!

Biff

"Excel Novice" wrote in message
...