Hello everyone,

I have a case where I have an excel file in which I store three categories of information (processes, rules,documents).
I have many groups of 3 categories and each category can have multiple rows.

For example:

Row 1 Process_1
Row 2 Rule_1_1
Row 3 Doc_1_1_1
Row 4 Doc_1_1_2
Row 5 Doc_1_1_3
Row 6 Process_2
Row 7 Rule_2_1
Row 8 Doc_2_1_1
Row 9 Doc_2_1_2
Row 10 Doc_2_1_3
Row 11 Rule_2_2
Row 12 Doc_2_2_1
Row 13 Doc_2_2_2
Row 14 Doc_2_2_3
I would like to apply some formulas on each Process, Rule, Doc, for example I want to count how many Docs are in a sheet, or thinks like this.

How can I categorize each row in order to use this categorization in formulas and other operations?

Thank you