Hi,

Given Column A is a list of students and Column B the group they beling to
(i.e. A1, A2, A3, B1, B2, B2), I am trying to find a formula that will find
the "next student" in a given group.

For example, sheet1! has:
Sarah Alpha 1
Mike Bravo 2
John Alpha 2
Rick Alpha 1
....


I would like to have a formula for cell B2 (find next Alpha 1) so that if
cell A1 has the name Sarah, it will return the next Alpha 1 student. In
this case, should return "Rick"

Is this possible?

Many thanks