ST Alpha - "ST Excel help needed: I have two spreadsheets to compare and mark all differences. Any favorite ways to do this?" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 155

ST Excel help needed: I have two spreadsheets to compare and mark all differences. Any favorite ways to do this?

Posted by Lon_cHaneY (aka con_carne) Oct 28 '10, 08:24

I will be looking at about three columns in each spreadsheet. Two of the columns contain data that I need to compare and note the changes. The third will simply be the "key," the column that should remain the same, but helps me tell the difference between the rows.

FWIW, this is two lists of our products and their dollar costs.

I'm thinking Autofilter might be able to get me somewhere, but I'm definitely open to awesome ST suggestions. TIA!

Responses:

two separate files, or two sheets in the same workbook? -- nm - Beryllium Oct 28, 08:26 5
- Two separate files, but I assumed that didn't matter. I was thinking of just pasting them both into a third sheet. -- nm - Lon_cHaneY Oct 28, 08:28 4
  - From what I recall of the last time I did it (four years ago) it takes a lot of extra effort to load data from separate files. Whereas you can just - Beryllium Oct 28, 08:30 3
    - YDC: Partially because it is still early, I am taking the path of least resistance... - Lon_cHaneY Oct 28, 08:45 2
      - I'm not sure I understand, but I do a Conditional Formatting in Excel 2007. - BloodyAxeSean Oct 28, 08:58 1
        
        OK, that definitely rings a bell from my Excel class. - Lon_cHaneY Oct 28, 09:09

Post a message top

ST Excel help needed: I have two spreadsheets to compare and mark all differences. Any favorite ways to do this?

Replies are disabled on threads older than 7 days.