Share via

Excel - How to delete rows with duplicate data in one column?

Anonymous
2024-04-08T16:21:28+00:00

In an Excel spreadsheet (Microsoft 365), where I have 200 columns and 200,000 rows, Column 'A' ("account number") may have multiple duplicates in this worksheet. I want to create a 'formula' (or other method) to delete (or hide) those rows where the account number is a duplicate. I don't have the time to right-click 'delete' the unwanted rows. I'm looking to see if Excel has the 'power' to do this through a formula or built in 'feature'. Please be very specific in the instructions if this can be accomplished. Much appreciated!

Microsoft 365 and Office | Excel | For business | Windows

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

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-04-08T16:27:36+00:00

    =COUNTIF($A$2:A2,A2)

    Then you can filter the column B with value 1.

    0 comments
  2. Anonymous
    2024-04-08T23:02:21+00:00

    Hi,

    Explore the usage of Data > Remove Duplicates.

    0 comments