My main data table looks as so:

Firm MarketShare
ABC 20
ABC 10
ABC 2

I would like to construct a new table that looks like this:

0 10 20

ABC 0 2 1
EFG
HIJ
KLM

The formula in b3 would find a match to A3 in table above, then count the
number of times that the marketshare is equal to 0. Then in c3, I would like
the formula to count the number of times the market share is greater than 0
(a2) and less than or equal to 10 (a3).

Thank you in advance.