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
Watch video Keep only the last update date of a record online without registration, duration hours minute second in high quality. This video was added by user Excel Exercice 15 April 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 973 once and liked it 38 people.