=INDEX($A$2:$A$6,SMALL(IF($B$2:$B$6=D2,ROW($B$2:$B $6)-ROW($B$2)+1),E2))

where D2 houses a class of interest like C and E2 N like 2.

The formula must be confirmed with control+shift+enter.

dziw wrote:
Ok, I have an Excel question... here's the scenario:
I've got 2 columns, we'll call Names and Classes...
Names: Classes:
Bob A
Dick B
Jane C
Harry A
Sue C

What I then want to do is return the name of the -n-th occurrence of
class -x-.
For example, I want the 2nd occurance of class "C", which would return:
"Sue".
Is there a way to do this?

Hope I was clear enough in what I'm trying to do. :)