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:

      PersonDate
      Recipient
      Jim03-01-2017Joris
      Henk07-02-2017Helena
      Piet04-01-2016Sophie