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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
..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.
 
And although not mentioned... generally the smallest common factor is
1, which doesn't really need a formula. :-)

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to determine the number of common factors? 3
How to determine the value from a list? 6
How to determine the values from a list? 9
Cannot sort data 6
First Value in Sorted Column is Not Sorted Properly 3
Getting the 2nd largest or smallest valuesin a range 5
SMALL FUNCTION - How it works 6
How to determine the value - 18 Dec? 5

Back
Top