counts of values before change in value

[kazekaze]

hello,


i have a list,
example,


a , b , b , a , a , e , a




i want to get the individual counts of a value before a change in value.
if i use "count", it simply gives me a=4. another issue is that the value "a" appears again later in the list.




i want the output to be,


a,1
b,2
a,2
e,1
a,1


any ideas how to do it?
thank you.

 

[ravishankar]

If the values are horizontal use the formula =if(B1=A1,column()-1,1)
If the values are vertical use the formula =if(B1=A1,row()-1,1)
drag it till the end of data
ravi shankar

 

[kazekaze]

If the values are horizontal use the formula =if(B1=A1,column()-1,1)
If the values are vertical use the formula =if(B1=A1,row()-1,1)
drag it till the end of data
ravi shankar

Hi ravi shankar, perhaps i did not phrase my question well.

attached a picture which hopefully makes it clearer.

 

[kazekaze]

https://imgur.com/a/4rpOZfm

 

[kazekaze]

Raw data		a	b	b	a	a	e	b	b
		value	counts
Desired output		a	1
		b	2
		a	2
		e	1
		b	2

<colgroup><col><col span="9"></colgroup><tbody>
</tbody>