6 Replies Latest reply on Sep 13, 2018 7:28 PM by Soham Wadekar

    How do I keep only the data rows with most recent dates?

    Ryan Dougal

      In my scenario, I have a database with case numbers and these cases are reviewed, sometimes multiple times with a new date and row added each time a case is discussed. How can I calculate or filter to only return complete rows of data with the most recent date? I am used to excel where I could just sort my most recent date and then remove duplicates. I need help on how to do this in excel.