2 Replies Latest reply on Feb 15, 2018 8:40 AM by Ethan Miller

    Show most recent rows per person

    Thijs Kooiman

      Dear all,


      I would like to create a table from the following Excel file. In the Excel file, you can see the person and the date when a call is placed and the recipient. I was wondering whether we could create a table with the most recent calls per person.


      I would like to know a formula that would allow me to achieve this.


      From the Excel file, we would get the following table: