Forum Discussion

pillaisg's avatar
pillaisg
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
Harun24HR's avatar
Harun24HR
Bronze Contributor
Oct 03, 2024

pillaisg Dynamic version of COUNTIF() or alternative but required latest versions of Excel.

=MAP(B3:B11,LAMBDA(x,SUM(--(B3:x=x))))
=MAP(B3:B11,LAMBDA(x,COUNTIFS(B3:x,x)))

 

 

Resources