Return Multiple records

I am trying to lookup data from a list and return multiple records. I cannot use row or column funtion as the tool will not allow.
any ideas appreciated.
I have tried something similar to this but its not working =INDEX(C$2:C$102,SMALL(IF($A$2:$A$102=$G$3,$K7-$K$7+1),$K7))

the attached excel has the data set. The attached picture has also a sample data that I need formula for.

Any help is appreacited

The long way: match rank index

Attachment 259721

Can it do normal Count instead?

Yes it can

I take it back. Apologies replied too soon. The tool does support countif but does not support array formulas/CSE-formulas. any work around for that ?

Then just change E2 to:

=IF(OR(A2="A",A2="B"),COUNT(IF($A$2:$A$56=A2,1))-((SUMPRODUCT(($A$2:$A$56=A2)*($B$2:$B$56>B2))+1)+COUNTIFS($B2:B$2,B2,$A2:$A$2,A2)-1)+1,"")

and enter as an array with Ctrl+Shift+Enter and copy it down as far as needed.

Ruh roh. I will consider nonarray possibilities.

thank you so much and I am really very sorry. I have attached a screen shot of the excel functions it supports.

I got it.

I turned E into a match if meeting Dynamic Selection.

I turned F into Rank-Countif for unique ranks

and changed the formulas in the results to pull from F instead of E.

Hurray!

Attachment 259910

Thanks you so much. You have solved it !!!! One last thing can i do the same with 2 criteria ?? I have tried doing it but am stuck in middle. Please see the attached

thanks so much again !!!!

You did everything perfect, the formula in I7 just needs to change to:

=COUNTIFS(A2:A17,J3,B2:B17,K3)