how to find duplicate values

[fazil]

Dear Chandoo


Kindly find below date for how to find duplicate values.i have been facing this problem last 1 year. could you please resolve this issue.method for finding duplication table by table

_________________A___________________ ________B____________

SITE NAME POLE NAME Duplicate SITE NAME POLE NAME

D1-1 60 60 D1-1 62

D1-1 62 62 D1-1 63A

D1-1 63A 3A D1-1 3A

D1-1 63 #N/A D1-1 60


D1-10 44 44 D1-10 44

D1-10 45A 45A D1-10 45A

D1-10 45B 45B D1-10 45

D1-10 70B 70B D1-10 45B

D1-10 46A 46A D1-10 70B

D1-10 79B #N/A D1-10 46A

D1-10 80 #N/A

D1-10 69 #N/A

D1-10 69A #N/A


D1-2 78 #N/A D1-2 80

D1-2 78A 78A D1-2 78A

D1-2 71 71 D1-2 71

D1-2 48A 48A D1-2 48A

D1-2 48 48 D1-2 48

D1-2 51A 51A D1-2 51A

D1-2 51 #N/A

D1-2 49A-1 #N/A

D1-2 49A-2 #N/A

D1-2 72-1 #N/A


kindly make separate above two tables


Formula i used to find Duplicate(=VLOOKUP(F8,$L$8:$L$13,1,0)


How to describe the method of duplication along with two row range with double cell criteria you can see Above Vlookup formula for finding values or criteria either present in this range or not


But in this case here with Duel row range with duel cell criteria Need to find duplication Table A Site name & Pole Name should find the same Table B if present should provide any kind of indication


Thank you


Kind Regards,


Fazil uddin

 

[vasim]

Better if you post a sample workbook


http://chandoo.org/forums/topic/posting-a-sample-workbook