Find a prime factor of a number

[pietermantel]

Say I have a number, for example 212, is there a formula which will find me a prime factor, preferably the smallest or else the largest, of that number (without counting 1 or the number itself)? In this case it would be 2. Note that the smallest factor of a number (again, not counting 1 or the number itself) must be prime. And I don't want to use VBA if possible.

 

[Fluff]

How about
=MIN(IF(MOD(A1,ROW(INDIRECT("2:"&INT(A1^0.5)))),"",ROW(INDIRECT("2:"&INT(A1^0.5)))))

This is an array funtion & must be confirmed with Ctrl shift enter, not just enter.

Formula courtesy of daddylonglegs https://www.excelforum.com/excel-fo...est-prime-factor-of-a-number.html#post2075405