I have several columns of information (i.e addresses) and one of the columns
has duplicate numbers. I want to remove the duplicates rows and retain the
other columns. I tried to do the Advanced filter but could specify which
column I needed duplicates to be searched. Any help is appreciated.