eliminating Multiple duplicate entries with condition

[Hui]

In C2: =(COUNTIFS($A$2:$A$724481,A2)+COUNTIFS($B$2:$B$724481,B2))=1

copy down

True if unique, False if not unique

 

[shankar_iyer83]

Hi hui..,


I changed some values..to check the formula..pls check..if its ok..as it always shows false..

 

[Hui]

If I go back to your post that includes

http://hotfile.com/dl/115372313/274a18f/extracts.xlsx.html


If the Location is the Same but DPIS is Different then ignore them

and

if the Location is the Same but DPIS is Same then ignore them

so the only option left is when the location is Unique

which is simply found with

C2: =COUNTIFS($B:$B,B2)=1

 

[Hui]

Also, though not specifically related to your question

When dealing with files this size try saving it as an Excel Binary File (*.xlsb)


The file will be about 1/2 to 2/3rds the size, open in half the time and save in about 1/3rd the time as it is now


You don't loose any other functionality