Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Streamlining sort
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
streamlining | Excel Discussion (Misc queries) | |||
Streamlining questionnaire analysis | Excel Discussion (Misc queries) | |||
Streamlining a long IF=(AND formula ?? | Excel Discussion (Misc queries) | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
Streamlining Code | Excel Discussion (Misc queries) |