Forum Discussion
Comparing columns with long decimal numbers
Hello. I have a bunch of long columns I need to compare that they look similar. Im trying to use
Find & Select → Go to special and pick Column differences, instead of looking at one row at the time. There are some differences at the last decimal digits (shown below), but its so small difference that it doesnt matter.
I have tried to remove decimals by using "decrease decimal places" for all the columns. But its not working as the whole decial number is still shown in the formula bar. Neither is the round function.
How can I compare the columns in a fast and simple way?
1 Reply
One simple solution that comes to my mind, on an auxiliary column:
=IF(ROUND(A2-B2,5)<>0,"Difference!","")
I have set the rounding up to 5 decimals, but you can put as many as you want. See attached sample workbook.
