Forum Discussion

Copper Contributor

Oct 03, 2024

Solved

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 ...

excel

SergeiBaklan
Oct 03, 2024
pillaisg

Here

in C3

=COUNTIF($B$3:$B3,$B3)

and drag it down
Count the instances of occurrence based on criteria.xlsx10 KB

SergeiBaklan

Diamond Contributor

Oct 03, 2024

pillaisg

Another variant for Excel 365

=LET(
  n, ROWS(Fruit),
  i, SEQUENCE(n),
  j, TOROW(i),
  MMULT((i>=j)*(Fruit=TRANSPOSE(Fruit) ), SEQUENCE(n,,,0) )
)

Count the instances of occurrence based on criteria.xlsx11 KB