I have a sheet of over 1500 rows, with multiple columns. In this sheet, certain rows may be duplicate, determined by only two of the many columns. Have been trying to figure out how to filter the sheet so that it will remove any duplicate records based on this criteria, however using advanced filtering even it seems to only filter out those rows where "every" column is a match.
Attached a short example of what I am dealing with here. The two columns which determine duplicity are D and G. If both columns are a match for a previous record, then I would like to filter out that row. Trying to find a non-technical method of doing this (ie non-VBA, macro) as it is something I will have to pass on to users without Excel knowledge.
Many thanks for any help.
Bookmarks