name
date point race c 1 1 A3 a 3 2 A3 b 1 6 A1 a 1 7 A1 b 2 7 A1 c 2 9 A1 a 2 3 A3 b 3 4 A2
Hi All, the above is the table, what i need is for each group of name a, b, and c, i want only 1 row to show the earliest date on which 3 points or under is scored
So the resulting table should be as following
name date point race a 2 3 A3 b 3 4 A2 c 1 1 A3
in the above table, group a and c have normal result as expected, but for b it has no match of points 3 or under, so i want the last row of the group by date(i.e. latest) to show, please help