DESCRIPTION
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.
Leave a Reply
You must be logged in to post a comment.