Finding Duplicate Record in more than one column

[peterwhite]

Hi, I have a excel 2003 worksheet that contains some records. Column A is
streetname and Column B is street number. The other columns contains
information regarding that address.

I would like to find addresses that are repeats, i.e. when more than 1
record having the same value for column A, at the same time, having the same
value for column B.

How should I start?

thank you all.

 

[Bernard Liengme]

Chip has lots about duplicates at www.cpearson.com

You might want to use a helper column with formula such as =A2&B2 to join
the two bits of data together for testing
best wishes

 

[DILipandey]

Hi Peter,

Please add two columns after your column A and column B and then put the
formulas as under and drag them till end.

Column C
=CONCATENATE(A1,B1)

Column D
=IF(C2="","",IF(COUNTIF($C$1:C2,C2)>1,COUNTIF($C$1:C2,C2)&" "&"times
repeated","Unique"))

Note: For column D only, you need to skip first cell i.e. D1 and start
filling the forumla from D2 onwards.

Let me know if it works, else I'll provide different solution based on your
problem
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India