View Single Post
  #1   Report Post  
TC
 
Posts: n/a
Default "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du

Excel 2003/ Is there a way I can use the "Criteria Range" in the
"Data/Filter/Advanced Filter" tool to select duplicates in a multi-column,
many-line spreadsheet by selecting based on only certain columns of
information. ie: columns including, Name, Address, City, State etc, as well
as columns containing data such as phone numbers which make all records
unique.