How to display duplicate among unique

Hello.

I have 503 products in my excel file which i got using import.io

Now i'd like to check if there are any duplicates in the file and which are those.

I've ran the formula

Please Login or Register  to view this content.

in my new Sheet3 and the result is 500 products, which points to 3 duplicates (atleast that's my thinking)

Is there any way to display those duplicates in sheet3, so i can delete them from my sheet1 ?

Thank you!

This is example of what i mean:

https://www.dropbox.com/s/rfle1x4767...mple.xlsx?dl=0

Tab DATA -> Remove duplicates

Originally Posted by sandy666

Tab DATA -> Remove duplicates

well yeah, that's a great shortcut . but this is work for school and im suppose to create a formula

read here: http://www.excelfunctions.net/remove...tes-excel.html

Originally Posted by sandy666

read here: http://www.excelfunctions.net/remove...tes-excel.html

thank you

You are welcome

If problem is resolved mark thread as solved. Thank you.