| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
| Drop-down list compling with If function. | Excel Worksheet Functions | |||
| Subtotals in a list | Excel Discussion (Misc queries) | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Hybrid Mode
