Forum Discussion
Count the instances of occurrence based on criteria.
I have used countif function for identifying the number of occcurance of a value in a specific column. Upon using this function, the value returned is the total number of occurrences whereas what is required is the number of instances in a sequence. For example,
Fruit Using Countif Required info.
Apple 3 1
Orange 2 1
Banana 4 1
Apple 3 2
Apple 3 3
Banana 4 2
Banana 4 3
Banana 4 4
Orange 2 2
Appreciate a solution for getting the required info.
3 Replies
Another variant for Excel 365
=LET( n, ROWS(Fruit), i, SEQUENCE(n), j, TOROW(i), MMULT((i>=j)*(Fruit=TRANSPOSE(Fruit) ), SEQUENCE(n,,,0) ) )
