Keep only the last update date of a record
When you have a file containing the history of your customers, products, references, .... you are bound to have duplicates.
So how do you keep only the information with the most recent update date?
Two techniques will be explained in this article.
One with an Excel formula and the other with Power Query
#update #excel #powerquery
00:00 Introduction
00:22 Method with MAXIFS
02:35 Method with Power Query