Skip to Content
0
Former Member
May 06, 2016 at 09:53 PM

Pull Last Comments by Operator

24 Views

Hello - I have a many tickets with multiple entries by different Operators and I want to pull the last comments made by each operator from each ticket.

Ticket Number Group Operator Datestamp Description Ticket287 Asupport Name A 1/5/16 3:39 PM Ticket comments A Ticket287 Asupport Name B 4/28/16 10:21 AM Ticket Comments B Ticket287 Asupport Name X 3/28/16 10:33 AM Ticket Comments X Ticket994 YYYY Name P 4/5/16 12:36 PM Ticket Comments P Ticket994 YYYY Name W 3/25/16 10:21 AM Ticket Comments W

I want the results to be the following

Ticket Number Group Operator Datestamp Description Ticket287 Asupport Name B 4/28/16 10:21 AM Ticket Comments B Ticket994 YYYY Name P 4/5/16 12:36 PM Ticket Comments P

Thank you!