Significant Numbers

[philippa]

Does anyone know if MS Excel can look for the next significant number in a
list?

 

[Gary''s Student]

Yes.
What is the significance criteria you wish to apply?

 

[Bernd P]

Hello,

I suggest to take either my formula or my UDF from
http://www.sulprobil.com/html/nsig.html
to calculate all significant digits and then extract the required one
with MID().

Regards,
Bernd