Comparing 2 spreadsheets and looking for the extra rows

[ste1200]

Hi, I have a spreadsheet which I upload to my website to populate its inventory. For some reason my website is showing approx. 60 more lines that I have uploaded (probably due to me not removing items from the site at the same time as removing them from the spreadsheet.

I have now downloaded my inventory from the website to a spreadsheet, so I have my inventory upload spreadsheet and my inventory download spreadsheet. What I need is a formula to compare the 2 spreadsheets so I can see which are duplicates thus seeing which lines are extra.

Can anyone help please ?

Thanks in advance
Ste

[scottyboy218]

Are you looking for duplicates in the download spreadsheet? Or are you trying to compare between the two speadsheets? This is fairly straightforward to do either way

[scottyboy218]

Here's an example of both ways of answering your question...let me know if this helps

duplicates.xls

[ste1200]

Yes that helped thank you.