Append numeric value to repeated names in a column

[manreddy]

append numeric value to repeated names a column, I tried with multi-row formula but it is not working as expected,Please help me to resolve this issue

Input

Name	Email
abc	abc@a.com
abc	abc1@a.com
bcd	bcd@a.com
def	def@a.com
ghi	ghi@a.com
abc	abc3@a.com
jkl	jkl@a.com
mno	mno@a.com
pqr	pqr@a.com
bcd	bcd@a.com
abc	abc@a.com
def	def@a.com

Output should be:

Name	Email	value
abc	abc@a.com	1
abc	abc1@a.com	2
bcd	bcd@a.com	1
def	def@a.com	1
ghi	ghi@a.com	1
abc	abc3@a.com	3
jkl	jkl@a.com	1
mno	mno@a.com	1
pqr	pqr@a.com	1
bcd	bcd@a.com	2
abc	abc@a.com	4
def	def@a.com	2

[atrozz]

Hello. Look my workflow. You need a running total tool.

Good Luck!!!

[manreddy]

It is working as expected..thanks for your quick response.

[atrozz]

You welcome and good luck!!!