Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
240
Views
Topic starter
I have two columns that i want to sort by, first by Account Name and then by Last Activity Date and I then want to remove duplicate Account Names. I do the sorts in order, and then remove the duplicate Account Names. For some reason it does not keep the most recent activity date, but seemingly one in the middle somewhere. Any ideas on how to resolve this issue?
Posted : 27/06/2018 2:14 pm
Hi Julie,
Indeed, some operations are not preserving the order of the rows. To overcome this, before removing duplicates add an index column, then sort after index after removing duplicates. Or, sort again by Account Name and Last Activity date.
Posted : 27/06/2018 11:42 pm
Topic starter
I changed the data type to date/time and then back to date, and re-sorted before removing duplicates and that seemed to work.
Thanks!
Posted : 28/06/2018 8:50 am
