View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
peterwhite peterwhite is offline
external usenet poster
 
Posts: 1
Default Finding Duplicate Record in more than one column

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.