Any function to determine the smallest common factor from a list?
 

Does anyone know any build-in feature in excel to determine the smallest /
largest common factor from a list of values?
such as
3
6
12, then the smallest common factor will be 3

Thank for any suggestion
Eric

Any function to determine the smallest common factor from a list?
 

..the smallest / largest common factor from a list of values?

=GCD(3,6,12)
3

Returns the greatest common divisor of two or more integers.
See LCM also.
--
HTH :)
Dana DeLouis
Windows XP & Office 2003


"Eric" wrote in message
...
Does anyone know any build-in feature in excel to determine the smallest /
largest common factor from a list of values?
such as
3
6
12, then the smallest common factor will be 3

Thank for any suggestion
Eric

Any function to determine the smallest common factor from a li
 

Thank you very much
Eric

"Dana DeLouis" wrote:

..the smallest / largest common factor from a list of values?

=GCD(3,6,12)
3

Returns the greatest common divisor of two or more integers.
See LCM also.
--
HTH :)
Dana DeLouis
Windows XP & Office 2003


"Eric" wrote in message
...
Does anyone know any build-in feature in excel to determine the smallest /
largest common factor from a list of values?
such as
3
6
12, then the smallest common factor will be 3

Thank for any suggestion
Eric

Any function to determine the smallest common factor from a list?
 

And although not mentioned... generally the smallest common factor is
1, which doesn't really need a formula. :-)

Scott

Dana DeLouis wrote:
..the smallest / largest common factor from a list of values?

=GCD(3,6,12)
3

Returns the greatest common divisor of two or more integers.
See LCM also.
--
HTH :)
Dana DeLouis
Windows XP & Office 2003


"Eric" wrote in message
...
Does anyone know any build-in feature in excel to determine the smallest /
largest common factor from a list of values?
such as
3
6
12, then the smallest common factor will be 3

Thank for any suggestion
Eric

Any function to determine the smallest common factor from a li
 

Hi scott, u are a wizard..
happy holidays...

"Scott" wrote:

And although not mentioned... generally the smallest common factor is
1, which doesn't really need a formula. :-)

Scott

Dana DeLouis wrote:
..the smallest / largest common factor from a list of values?

=GCD(3,6,12)
3

Returns the greatest common divisor of two or more integers.
See LCM also.
--
HTH :)
Dana DeLouis
Windows XP & Office 2003


"Eric" wrote in message
...
Does anyone know any build-in feature in excel to determine the smallest /
largest common factor from a list of values?
such as
3
6
12, then the smallest common factor will be 3

Thank for any suggestion
Eric