AnsweredAssumed Answered

Multiple Records Do a Find For Only Most Recent

Question asked by cbuck on Oct 29, 2017
Latest reply on Oct 29, 2017 by philmodjunk

I have a data table that has multiple records for example

 

 

Bob     Win     2017

Bob     Lost     2016

Bob     Win     2015

Chris     Lost     2017

Chris     Win     2016

Chris     Lost     2012

 

What I would like is it to return

Bob     Win     2017

Chris     Lost     2017

 

So the latest date. Whats the best way to do this?    

Outcomes