USing Rank & Array formula to Restrict?

[far]

I was hooping to use the Rank formula on a list of
Products sales. Perhaps using an Array formula? I am not
sure how to do it.

I was hoping to use Rank that would look at the entire
list, restrict on "Glove" to give the rank that line item
compared to all "Glove" sales.

Glove $10
Ball $11
Bat $13
Glove $11
Ball $14
Bat $15
Glove $16
Ball $17
Bat $19

 

[Aladin Akyurek]

Assuming that A2:B10 houses the sample you provided, the following will rank
by each distinct item/product...

In C2 enter & copy down:

=SUMPRODUCT(($A$2:$A$10=A2)*(B2<$B$2:$B$10))+1

If you want a ranking wrt Glove only...

In C1 enter: Glove

In C2 enter & copy down:

=IF(A2=$C$1,RANK(B2,$B$2:$B$10),"")

In D1 enter: Rank

In D2 enter & copy down:

=IF(N(C2),RANK(C2,$C$2:$C$10,1),"")