Share via

Excel 365 remove duplicates based on most recent date

Anonymous
2020-10-06T17:03:16+00:00

I have multiple columns where Column B is a date and Column C is a name.  There are many duplicates in Column C and I want to remove the older duplicates, but based on the most recent date in Column B.

Microsoft 365 and Office | Excel | For home | 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

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-10-06T19:03:15+00:00

    Hi salynch51

    To better understand your request

    Could you please clarify,

    What would be the output for the scenario in the picture below?

    Which rows would be deleted?

    Regards

    Jeovany

    0 comments
  2. Anonymous
    2020-10-06T19:13:25+00:00

    re:  remove dupes, keeping most recent date

    "Remove Duplicates" is found on the Ribbon | Data (tab) | Data Tools (group)

     Select both columns of the data before sorting and removal.

    Image

    'NLtL

    free Professional_Compare workbook (can also clean worksheets)

    https://1drv.ms/u/s!Au8Lyt79SOuhZ\_zj8wEtOjDcqAI?e=MrzfpA

    2 people found this answer helpful.
    0 comments
  3. Anonymous
    2020-10-11T11:01:37+00:00

    Hi salynch51,

    I’m writing to follow up on this thread.

    May I know if you need further help? If so, please feel free to contact us.

    Best Regards,

    May

    0 comments