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
|