Hi, I am trying to set up some formula to revert status based on latest status date for listed IDs. I know I can sort it out from newest to oldest and run vlookup to take the first found value but looking for some smarter solution. Thank you for any hint!
Bookmarks