On the spreadsheet there are two subsets of data that are separated by color based on where I pulled the information from. Within these subsets are duplicate entries.
I do not want to simply remove duplicates as it is key to know the source of the data. As well as what I am trying to view are those without duplicate entries (unique values ONLY).
I am trying to build an advanced filter that will select all fields so the list range will be column/row A:1 to [whatever the last column/row] is for the xls.
I only want to use the first name and last name as the criteria to use to determine a unique value.
I can copy the data to separate location within the xls or filter in place.
The key here is after the filtering has taken place I only want unique values left.
In this instance the unique value would be those records that did not have a duplicate entry. Not only one instance of the duplicate record and those single entries. I only want the single entries to be left at the end of the filtering.
What I am finding is that it is not bringing over unique values only.
As an end result I should only have those fields that were unique (meaning no duplicate was found). Not just removing the duplicate.