Hi there
I was wondering if anyone can help me out here. I have two columns of numbers e.g Column A Column B
135 135
86 86
171 171
etc etc
And when I run my conditional formatting for Duplicate numbers they all match as expected. But when I run Auto Sum on each column the total for each column is different column A amounts to 23687 and column B amounts to 23744 how could that be?. I would be very grateful if anyone can solve this problem.
I was wondering if anyone can help me out here. I have two columns of numbers e.g Column A Column B
135 135
86 86
171 171
etc etc
And when I run my conditional formatting for Duplicate numbers they all match as expected. But when I run Auto Sum on each column the total for each column is different column A amounts to 23687 and column B amounts to 23744 how could that be?. I would be very grateful if anyone can solve this problem.