Ranking with exclusions

Assuming the highest value should be ranked 1 you can do that without any helper cells if you use this formula in C2 copied down

=IF(A2="apple","",COUNTIFS(A:A,"<>apple",B:B,">"&B2)+1)

If you want to rank the lowest value as 1 then just change the ">" to a "<"