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?

​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?  Read More

​