Q:

Is there a way to find the largest number of decimal places in an Excel

I have a sheet in Excel which contains a lot of numbers to varying decimal places. I'm trying to create a table in MySQL to store this data as efficiently as possible, but I need to know the highest number of decimal places in each column. Is there a function which I can use to work this out?
My dataset looks something like this:
Item | Val 1 | Val 2 | Val 3
=====|=======|=======|=======
1    | x.xxx | x.xx  | xx.xx
...  | x.xx  | x.x   | xx.xxx
n    | xx.x  | x.xx  | xx.xx

For example, in the Val 1 column, the highest number of decimal places is 3. Given the sheer size of the full dataset, however, it would be difficult for me to manually go through every column and count the highest number of decimal places.

A:

May be it can help you. It is an excel formula.
=MAX(LEN(MID(B2:B5,SEARCH(".",B2:B5)+1,LEN(B2:B5)-SEARCH(".",B2:B5))))

Press Ctrl+Shift+Enter as it is an array formula.

