Let's assume that your target columns are A, B, C, D and F. Place this in an
open cell (say J13):
And use $J$12:$J$13 as your criteria range, ensuring that *J12* is empty.
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