alphabetical repetitions count

[tarun_kumar10]

How to get the count for alphabetical repetitions.

for example- Navneet    alphabetical  E comes two times 

[tarun_kumar10]

Customer alphabetical repetitions Count

Navneet	ee	2
Marge	None	0
Totttal	ttt	3

[flying008]

Hi, @tarun_kumar10 

Can 'Navenet' also as your mind?

[aatalai]

@tarun_kumar10 what if there are multip;le repeated letters, e.g.

aaaddt?

[tarun_kumar10]

It can be. 

[tarun_kumar10]

Only continuous repetitions count.

[tarun_kumar10]

Can you share out put file 

[flying008]

Hi, @tarun_kumar10 

If you only have one pattern, please follow this :

[tarun_kumar10]

Navneet	ee	2
Marge	None	0
Totttal	ttt	3

 Any alphabetical  can be repeat . So need to count

[flying008 · Accepted solution]

Hi, @tarun_kumar10 

The formula as above gif, if can help get your want output, please mark it as a solution and give a like for more share.