Forum Discussion
Compare columns
I want two compare columns using Find & Select → Go to special and pick Column differences.
One of the columns is just number and the other one is number with a formula. It seems like its not possible to compare them when one of the has formula. How can I do that?
Instead of using Row Differences, calculate the differences in a helper column.
You'll see that none of the cells in column E is exactly equal to the corresponding cell in column D.
With a few exceptions, the differences are very small.
To work around this, note that the cells in column D have 10 significant decimal places.
So it makes sense to round the result of the formulas in column E to 10 decimal places too.
The differences vanish, except for those few rows where the difference is larger:
In a small test it appears to work correctly. Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar Here is a woorkbook sample. I wrote wrong in the post. Im trying to use row differences instead of column differenses. Im trying to compare the columns D and E, but it seems to be not working
Instead of using Row Differences, calculate the differences in a helper column.
You'll see that none of the cells in column E is exactly equal to the corresponding cell in column D.
With a few exceptions, the differences are very small.
To work around this, note that the cells in column D have 10 significant decimal places.
So it makes sense to round the result of the formulas in column E to 10 decimal places too.
The differences vanish, except for those few rows where the difference is larger:
