duplicate entries

[cwissy]

Is there a way to filter out duplicate records in a spreadsheet?

 

[Griffyn]

yes. this has been answered before recently, so be sure to use the search feature on the forum.

The easiest way is to use a spare column, sort the worksheet into order so that duplicate rows will be next to each other, and use a formula such as this:

=IF(AND(A2=A1,B2=B1),1,0)

Then use the autofilter to not show any 1's.

 

[cwissy]

I used keyword search 'duplicate records' and didn't find anything. Thanks for the info

 

[Phaed]

have 2 agree. great site, but search capabilities r poor. i have made dozens of searches using search, and only once have i ever found anything. even 4 posts that I KNOW exited, as I posted them.

 

[KenWright]

Plenty of reading here:-

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

Regards
Ken................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------