Removing Duplicates Based on Date

NordicWalker

New Member
Joined
Mar 18, 2019
Messages
1
I'm new at this, so if I don't explain my problem correctly, please don't shout :cool:

Column A = date
Column B = name (sometimes multiple occurrences / date)

>5000 rows

I want it to show ONE occurrence of each name per date.

1) Does that make sense?

2) Can it be done?

Cheers
~Phil
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

footoo

Well-known Member
Joined
Sep 21, 2016
Messages
3,049
Office Version
  1. 2016
Platform
  1. Windows
Assuming row 1 is a header row, in C2 enter =A2 & B2 and fill down
Filter by column C for Unique Records Only
Select columns A:B and go to SpecialCells/VisibleCellsOnly
Copy and paste to D1
Delete columns A:C
 

Watch MrExcel Video

Forum statistics

Threads
1,109,032
Messages
5,526,355
Members
409,697
Latest member
christopherlewis1620

This Week's Hot Topics

Top