Apply row count of sub grooup in each row of sub group

[peasther]

In Col X of the attachment, I have manually entered the count of the rows within each sub group, as determined by the counter in Col W. How can I do this automatically? I need this because when I filter the spread sheet by Rank, I need to know how many selections, of the filter Rank query, were in a sub group of ? number.

[gak67]

Please Login or Register  to view this content.

[peasther]

Champion works a treat. Thankyou so much.