Excel: compare two decimal values and return number of decimal places correct


I am looking for a formula that can compare two decimal values and return how many decimal values are correct. Example: Cell AK351 = 347.980813837264 Cell BU351 = 347.980813859881 I need to compare how many decimal places in cell bu351 are correct compared to cell ak351. In this example the formula would return 7. Thanks for the help. Mike


This question generated 25 answers. To proceed to the answers, click here.

This thread is current as of March 03, 2017.


For more resources for Microsoft Excel