I'll try to keep this concise. My issue regards sorting entries in a long list (circa 300) of categories, and also identifying the total number of entries in each of these categories.

I have a list of 200 expandable categories (in column A), each containing numerous entries (in another column).

I want to :

a) sort (highest to lowest) the entries in each expandable category (very important that they are only sorted within the category, not the whole list)

b) identify how many entries there are in each category. (one value for each category showing the number of entries therein)

How can I do this in the most automated , efficient way?

Your help is much appreciated. Thank you in advance!