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.
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 1Orange 2 1Banana 4 1Apple 3 2Apple 3 3Banana 4 2Banana 4 3Banana 4 4Orange 2 2 Appreciate a solution for getting the required info. Read More