Here's what I need to figure out:
Column1 has a list of 6-digit id strings sorted ascending with a varying amount of duplicates for each id string
Column2 has accompanying dates entries of the ids
I need to figure out a formula that counts ids with the most recent date, so that I can filter my list down to having 1 distinct entry per id based on the most recent date.
I've attached an example. Thanks in advance.
Bookmarks