How To Compare 2 Spreadsheets?

Hi,

I have two sets of spreadsheets. One has new statistics the other has older statistics. The newer spreadsheet has additional rows. What I want to do is remove the newer additional rows so I can compare like with like.

Here's an example

S/sheet1
Column C
word1
word1
word1
word2
word3
word3

S/sheet 2
Column C
word1
word1
word1
word8
word
word2
word3
word3
word90

As you can see s/sheet 2 has additional rows but also rows which match spreadsheet 1. I want to remove the entire rows in spreadsheet 2 that don't match spreadsheet 1, without affecting the other columns of data associated with the rows.


Does any of that make sense? If so, how do I do this?

Thanks,
Alex