I have 2 reports (approx 8000 lines) with similar data that I need to match
up and find differences in. I copy and paste them side by side onto one sheet
(1 has 5 columns--the other has 12). I insert columns with formulas to find
the differences between the items that should be common--SSN, Dollar amounts,
and hours. I sort by SSN and term on each side. That should match them up.
However, if one report has a student and the other does not, my formula
pinpoints it by showing a variance in SSN. I then have to insert cells to get
my common students to line up again. (Make any sense?) Anyway, I was
wondering if anyone has any suggestions as to how I can streamline this
process. Thanks in advance!