How do I remove or filter out duplicate records in an Excel Spreadsheet?

You can use Data/Filter/Advanced Filter

Selet your range, check the unique values box, and if you want to copy
the unique values to another range, then select the Copy To box & pick
a cell to copy to.

---Glenn


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=512824

I am trying to remove or separate all my records that occur more than once,
not extract the records that are not duplicates....the advance filter does
not do that as I understand it.

"gjcase" wrote:


You can use Data/Filter/Advanced Filter

Selet your range, check the unique values box, and if you want to copy
the unique values to another range, then select the Copy To box & pick
a cell to copy to.

---Glenn


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=512824

You can use the techniques on Chip Pearson's site, to mark and delete
the duplicates in the source data:

http://www.cpearson.com/excel/duplicat.htm


geo wrote:
How do I remove or filter out duplicate records in an Excel Spreadsheet?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

If you want to find "Duplicates" the easiest way I have found is to sort
your records on the column you want to check. Then have the cell above
the records you want to check for duplicates as a "blank" or a column
Title. For this example I would start the records you want to check at
Cell A2 (you always want a Not Dup for your first value): Then enter
the following formula in whatever column you want and copy it down the
list:
=IF(A2=A1,"Dup","Not Dup"). You Can enter whatever values you want for
"DUP" and "Not Dup"


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=512824