muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi guys..
i'm looking for in excel formula to easy determine a number has factors (2 problems) :
a. how many list of factors a number?
b. counting list of factors?
<tbody>
</tbody>
any help, greatly appreciated...
m.susanto
i'm looking for in excel formula to easy determine a number has factors (2 problems) :
a. how many list of factors a number?
b. counting list of factors?
number | list of factors (expected result a) | count factors (expected result b) |
10 | {1;2;5} | 3 |
90 | {1;2;3;5;6;9;10;15;18;30;45;90} | 12 |
etc.. |
<tbody>
</tbody>
any help, greatly appreciated...
m.susanto
Last edited: