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.