How do I remove duplicates without deleting the entire row for a very large volume sheet?

Question

How do I remove duplicates without deleting the entire row for a very large volume sheet?

Anonymous

I am trying to delete duplicate values in cells/rows. I have six columns that contain phone numbers as values and need to get rid of the repeated numbers only leaving behind one copy of the same value while deleting the rest of the duplicates. The sheet is very large, around 55k rows, so the replace feature is not applicable.

Thanks

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Answer 1

Dear Harmik,

I'm Ibhadighi and i'd happily help you with your question. In this fdorum, we are Microsoft consumers just like yourself.

Thank you for posting your question in our community.

You can use the Remove Duplicates feature in Excel to delete duplicate values in cells/rows. Here’s how:

Select the range of cells that contain the duplicate values. Click on the Data tab in the ribbon. In the Data Tools group, click on Remove Duplicates. In the Remove Duplicates dialog box, make sure all columns are checked and then click OK. This will remove all duplicate values from the selected range of cells, leaving only unique values. Let me know if this helps!

Best Regards, IBHADIGHI

Give back to the community. Help the next person with this problem by inicating whether this answer solved your problem.d Click Yes or No at the bottom.

Answer 2

Ashish Mathur 101.8K Volunteer Moderator

Hi,

Share some data to work with and show the expected result.

0 comments

Share via

How do I remove duplicates without deleting the entire row for a very large volume sheet?

2 answers