rows side by side - looking for discrepences in numbers.

i have over 2000 numbers in 2 rows that i have to look for discrepancies. they are suppose to match up, but dont because my SUMS are off by 49. so im looking where that 49 is. so now im on this forum to try to get some help. any help please on how i can find the numbers that dont match up, thanks


my eyes will thank you

Hi, this may sound like a dumb answer but it's pretty easy to do. I presume you are looking for the number in column B to be the same as column A? If so a simple way of checking would be to copy a formula into all the cells of column C simply as =A1-B1 etc., this way all values in column C will be zero except for the ones that have an error.

Or use conditional formatting, assuming your two columns are A and B

Select column A

Format > Conditional formatting > choose "formula is" from dropdown and type this formula in the box

=(A1<>B1)*(A1<>"")

select suitable format, e.g. red fill pattern > OK