I started with the code from he
http://office.microsoft.com/en-us/ex...260381033.aspx

My current formula is:
=INDEX(tests!$C$2:$G$30000,SMALL(IF(tests!$C$2:$C$ 30000=A$2,ROW(tests!$C$2:$G$30000)),ROW(1:1)),2)

I don't fully understand how the row function works, specifically how the
ROW(1:1) statement plays into the SMALL function or even what ROW(1:1)
signifies, and because of this I can't figure out why the whole formula is
basically doing things right but instead of identifying occurrences of A$2
and spitting out that data, it's identifying occurrences of A$2 and spitting
out the data of the next line below.

Any help would be greatly appreciated.

Ryan