Excel Magic Trick 1091: Count Number of Items In Row For First Occurrence of Each Group

See how to count the number of items entered into the row that corresponds to the first occurrence of each Group Number using:
1) INDEX, MATCH and COUNTA functions to "lookup a row" for the first occurrence of each group and then count how many items have been entered in row (count non-empty cells).
2) OFFSET, MATCH and COUNTA functions to define a new range for each group and then count how many items have been entered in row (count non-empty cells).

Dynamic range. Dynamic range with INDEX. Dynamic range with OFFSET. Find for row for each group.

[ExcelVbaIsFun]

What a beautiful manipulation of index and match. You've done it again, sir. Very wonderful lesson!!!

[excelisfun]

Excel Magic Trick 1091: Count Number of Items In Row For First Occurrence of Each Group 

Comparison of INDEX and OFFSET functions! 

[samnangchhing]

If I want to know the row number how to use formula ? Example: Number 1 and Person P4 and how to use the formula to find row number?

[DonutCloud]

Dear Sir,


Greetings!  

Im writing because im tired for looking of the function which will help me in counting the below:
Name   Dposition    Performance
Eric       Director                A
Jhone     Labor                  C
Petter     Labor                  B
Joe         Labor                  A
Samir      Labor                  B
I would like to know how many A, B & C did Eric write for the mentioned names.



Your prompt help is highly appreciated.

Thanks and regards.