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. :)


--
dziw
------------------------------------------------------------------------
dziw's Profile: http://www.excelforum.com/member.php...o&userid=10422
View this thread: http://www.excelforum.com/showthread...hreadid=470591