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.