Excel Incrementation

[shethuraman]

all Hi I am working on excel to get an ouput like this


Cloumn A Column B

Green 1
Green 2
Blue 1
Blue 2
Green 3
Red 1

Like this whenever i enter a new name in column A it has to tell the
whether the nameis appearing for the first time / 2nd / 3rd etc.,

can u pl solve this problem

 

[Arvi Laanemets]

Hi

Into B1 enter the formula
=COUNTIF(A$1:A1,A1)
and copy down