Hello, I have a dataset that lists records by ID of exam date and result. I only want to output the data after an ID's second last 'PASS'. How do I achieve this? Many thanks. Max Source data: ID DATE RESULT 85 15JAN2010 FAIL 85 25JAN2010 PASS 85 15FEB2011 FAIL 85 25FEB2011 PASS 85 01MAR2011 FAIL 85 07MAR2011 FAIL 85 10MAR2011 PASS 66 10OCT2015 FAIL 66 15OCT2015 PASS 66 10SEP2016 FAIL 66 15SEP2016 PASS Desired output data: 85 01MAR2011 FAIL 85 07MAR2011 FAIL 85 10MAR2011 PASS 66 10SEP2016 FAIL 66 15SEP2016 PASS
... View more