View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to determine the number of common factors?

Does anyone have any suggestions on how to determine the number of common
factors based on given number? For example,
10 is given in cell A1, then the common factors for 10 are 1,2,5,10. There
are 4 numbers for common factors, then I will return 4 in cell B1.
I will try different number in cell A1,
Does anyone have any suggestions on how to determine the number of common
factors in cell B2?
Thanks in advance for any suggestions
Eric