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.

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"peterwhite" wrote in message
...
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.

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.)


New Delhi, India


"peterwhite" wrote:

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.