Keep only the last update date of a record

Published: 15 April 2024
on channel: Excel Exercice
1,723
40

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


On this page of the site you can watch the video online Keep only the last update date of a record with a duration of hours minute second in good quality, which was uploaded by the user Excel Exercice 15 April 2024, share the link with friends and acquaintances, this video has already been watched 1,723 times on youtube and it was liked by 40 viewers. Enjoy your viewing!