Hello All.

See the example below:

A B
9 3
9 1
9 2
8 1
7
9
6
5
9
9
4
6
9
7

I need a formular in column B that counts consecutively the number of 9s that appear in column A. Thank you.