Forum Discussion
Need a function help please
If with Power Query that is like
- query named range
- select Part and Other columns, Keep Duplicates (records without duplication will be removed)
- sort Date in descending order
- select Part and Other columns, Remove Duplicates (only first of each duplicate will be kept)
- load result back into Excel sheet
For reliability I'd fix sort result in memory by Table.Buffer() or by adding Index column (remove it at the end).
Above is for all duplicates. If we consider only records with 5 or more duplicates few more steps shall be added. Like Group by Part and Other counting combinations, remove records with less than 5 duplicates, merge source table with grouping result.
Result is second sheet attached.
Sergei, there are no duplicates as per your assumption. They are different shipments with different qty on different dates. They may be on the same dates but different qty, just different time of day but we don’t have time stamped so records show same dates.