Hi everyone, I wanted to know whether there is a simple way to calculate the count of occurance of a particular value in a particular field from row 1 till the row getting processed? Following is an example of what I need: Status Countif Formula Y 1 =COUNTIF($A$2:$A2,A2) Y 2 =COUNTIF($A$2:$A3,A3) Y 3 =COUNTIF($A$2:$A4,A4) X 1 =COUNTIF($A$2:$A5,A5) Y 4 =COUNTIF($A$2:$A6,A6) X 2 =COUNTIF($A$2:$A7,A7) Y 5 =COUNTIF($A$2:$A8,A8)
... View more