rewrite aggregate function

[Eastw00d]

Hi, I am working with this function, but I am struggling with the counting at the beginning of a new category.

Please Login or Register  to view this content.

In the red part the function is counting beginning from row 2, but I need him to count with 1 at the start of a new category.
I was already playing with the number of occurences of the category, but I fail to see how to do it.
Ideally it would be best if the category in column H is calculated too.

Maybe someone has a (another) solution?

In the added sheet I have an extract of a much bigger dataset


Cheers
Erwin

[Fluff13]

How about
=INDEX($C$2:$C$11,AGGREGATE(15,6,(ROW($B$2:$B$11)-ROW($B$2)+1)/(($A$2:$A$11=$G$2)*($B$2:$B$11=$H2)),COUNTIFS(H$2:H2,H2)))

[Eastw00d]

Thanks, this helps me from my headache!

Cheers
Erwin

[Fluff13]

You're welcome & thanks for the feedback.