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?

​Hello. I have a bunch of long columns I need to compare that they look similar. Im trying to useFind & 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?   Read More

​