Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
147
Views
Topic starter
Is there a standard approach to removing the first duplicate date in a group?
I tried Grouping by Location and Dates, but not quite able to flag and remove first duplicate.
Many Thanks
Robb
Posted : 27/10/2020 8:09 pm
Hi Robert,
If you select the Location Number and Dates column, then Home tab > Remove Rows > Remove duplicates, the first record is the one that is retained.
Mynda
Posted : 28/10/2020 5:55 am
