Hi, I am working with this function, but I am struggling with the counting at the beginning of a new category.
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
Bookmarks