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

E

Eric

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
 
D

Dana DeLouis

..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.
 
S

Scott

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

Scott
 
D

driller

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

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

Scott
Click to expand...
 
Top