Can I compare 2 Excel spreadsheets cell by cell?


  1. Posts : 17
    Win 7 home premium 64 bit
       #1

    Can I compare 2 Excel spreadsheets cell by cell?


    I have an Excel 2010 workbook comprising a simple organization membership list, consisting of names, addresses, etc., for nearly 2,000 members, grouped into 5 chapters' sheets, in a single Excel 2010 file. Every time I sit down to enter updates for any member, or add new members, etc., I always start by saving my most recent version of the workbook with the date I last updated it in the filename, and then when I finish my updates for the day, I save the current day's updated workbook with the current day's date in the filename, etc. So after a while, I've got quite a stack of versions of the same workbook, albeit with slightly different data in some of the cells, from version to version.

    Near the end of the year, it'd be neat to be able to compare the beginning and end of year versions, cell by cell, to see what changed.

    Ideally, I'd like to sort of "subtract" one workbook from the other, cell by cell, and display something in the results that shows cells that differ btwn workbooks and cells that don't.

    Obviously, I could just print the two versions, and plow through them both, side by side. But they're nearly 2,000 rows deep, all things considered, and with all the data we compile for each member, each row goes up to column AT! That's a lotta data to compare visually cell by cell.

    Is anything like what I'd like to do possible?

    Thx.
      My Computer


  2. Posts : 330
    Microsoft Windows 7 Professional 64-bit SP1
       #2

    I think this might help if I read this correctly. I used this before to compare three lists I made a long time ago, then when I needed to update them I didn't want to sift through hundreds of entries.

    Compare Two Lists in Excel - Easy Excel Tutorial

    From MS https://support.microsoft.com/kb/213367

    Also 4 Ways to Compare Data in Excel - wikiHow
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 08:15.
Find Us