SOLVED

# Compare columns

Copper Contributor

# 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?

3 Replies

# Re: Compare columns

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?

# Re: Compare columns

@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

best response confirmed by LFM123 (Copper Contributor)
Solution

# Re: Compare columns

@LFM123

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:

1 best response

Accepted Solutions
best response confirmed by LFM123 (Copper Contributor)
Solution

# Re: Compare columns

@LFM123

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: