I have a data set, first column is the ID, second is Date and Third is score.

Below is a sample data...

Now, how do i filter out the only the 2nd visit data of A, B & C

no      date      score

A 01-01-2010 10

A 01-01-2011 50

A 01-01-2012 183

A 05-03-2025 4

B 06-07-1998 32

B 02-02-2010 145

B 02-02-2011 145

B 02-02-2013 247

C 02-05-1976 127

C 02-04-2015 124

C 03-03-2025 0

More Thirumugam M's questions See All
Similar questions and discussions