4 Replies Latest reply on Jun 26, 2018 12:37 AM by anand mishra

    Display only one row from multiple rows

    Jyothi Hegde

      Hello everyone,

       

      I have a worksheet with the below data , multiple dates for the same PatNAme for some PatNAmes. . I would like to display only the first row (min date value) for each PatName.. That's one row for each patient. like the Patient BBB should have only the row with 4/18/2018 value.

       

      PatName
      PatMRN
      PatAge
      PatProvAdmit Date
      AAA12300023XXX5/22/2018
      BBB23400025YYY4/18/2018 1:32:00 PM
      4/25/2018 4:28:00 PM
      4/25/2018 12:30:00 PM
      CCC45600045zzz5:27:2018 5:27:00 PM

       

      Any help would be greatly appreciated.

       

      Thanks!