NEED HELP IN FINDING DUPLICATE VALUES IN LARGE DATA EXCEL

[Vijardhan]

Hi,

Need Help in finding Duplicate values in Large data excel.

Tried conditional formatting but since data is large in excel the excel does not respond .

We need FSN value corresponding to SKU TO FIND COLUMN which should be same as SELLER SKU

BELOW IS THE FILE

https://drive.google.com/file/d/0B84P5VS3G6tMNXh2U0hOeFdKSVU/view?usp=sharing

 

[Awesome Wally]

Have you tried the solutions presented here: http://chandoo.org/wp/2008/11/06/unique-duplicate-missing-items-excel-help/

 

[David Evans]

Have you thought about using Power Query to bring in your data without duplicates?

https://support.office.com/en-us/ar...er-Query-d9cffc69-dc5d-4d94-8b66-72779688874d