• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 365
  • Last Modified:

How delete duplicate records

I have an Excel file which contains two rows.  There are several cases where the same exact data is duplicated in both cells in the row.  Is there a way delete the duplicate records and leave just one record?

--Steve
0
SteveL13
Asked:
SteveL13
  • 2
1 Solution
 
Martin LissOlder than dirtCommented:
Just go to the Data tab and click Remove Duplicates.
0
 
SteveL13Author Commented:
Wow.  Never knew it was there.  Thanks.
0
 
Martin LissOlder than dirtCommented:
You're welcome and I'm glad I was able to help. We're all learning:)

Marty - MVP 2009 to 2013
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now