I am a supporter of
St. Joseph's hospice.
 If you find this site useful or if it helped you, consider a small donation to
St. Joseph's, please.

Information on
St. Joseph's

JustGiving - Sponsor me now!

 

Count Trailing Zeros
Count_Trailing_Zeros_Example

Funnily enough, the non-array formula in B8 is not the fastest one. The array formula in B5 is faster, also the one in B6 (but this is a tick slower than B5).

The formula in B7 would have been my favourite one if Excel© had a worksheet function “REVERSE”. Then we could just say
=LEN(A1)-LEN(--REVERSE(A1))

Please note that only the formulas in B5 and B6 return correct results for negative inputs or inputs with decimals. The other one assume positive integer inputs.

Sulprobil   Get it done   Contact   Disclaimer   Download