I want to delete rows in my excel sheet based on a column where values are repeating.

Excel Sheet with repeated column values

Now in the above image I want to remove rows 3,4,5,7,8,9,10 as it has values repeating in column A. This is a small example , but the actual data contains thousands of rows. Can anyone let me know if there any logical formula I can apply.

  • 1
    Welcome to Super User. New members commonly mistake this for a service site where we will do the work. It is a Q&A community where specific questions are asked after you have attempted something and get stuck. Please add details of what you have tried so far, including scripts, code or formulas, and we will try to help. If you need more info about asking questions, check out How to Ask in the help center. – CharlieRB Jan 16 '17 at 12:42
  • There is no Logical formula to delete rows. You will have to use vba such as this – Jonathan Jan 16 '17 at 13:28

You can use Remove Duplicates under Data Tab in Excel.
First sort your data to make the row that contains all the data is the first in the duplicate, for example: Name (A to Z), Address (Z to A), Age (largest to smallest) or if your data is the same as shown above it is ok. Select all your data and click on Remove Duplicates (My Data has Headers should be selected) and choose only Name column and Ok.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.