Merging Spreadsheets and deleting old data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have a spreadsheet used to show account names and their assignments with quite a bit of data. Apprx 11K rows. Every few weeks, we save as and date the spreadsheet to keep a record of what the data was at certain points. We have now found that quite a bit of data has been deleted from the current spreadsheet and the last time this data was included was back in early Dec. So, I have a spreadsheet from Dec that has all the correct accounts, but the a lot of the assignments have been updated since then. I need to combine the two, and delete any duplicate rows based on account name from the older spreadsheet. Like I said, I have 11K+ rows and could not do a stare and compare to find the deletions... Thanks for any help.
 
Back
Top