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....
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.