Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

duplicate entries

Status
Not open for further replies.
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:

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

Then use the autofilter to not show any 1's.
 
I used keyword search 'duplicate records' and didn't find anything. Thanks for the info
 
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.
 
Plenty of reading here:-


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

----------------------------------------------------------------------------
[peace]It's easier to beg forgiveness than ask permission[2thumbsup]

----------------------------------------------------------------------------
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top