Afternoon...

In have two spreadsheets where i have a number of duplicated information. My
objective is to eliminate this duplication that i have. I need to know is
there any way that excel will be able to pickup if there is duplication, by
running a vlookup or something? For me to actually go threw both spreadsheets
to run a cross reference will be to time consuming, is there an alternative?
Please i need assistance