Return the instance of the value in the column in the next cell

Hi all,

This is simple logic i guess.... but m missing something somewhere.

There are list of values (text) in one column some of them repetitive.
I want a macro which returns the instance of that value in the column.
Ex:

Column1 Column2
high ------ 1
low ------ 1
idiot ------ 1
high ------ 2
high ------ 3
low ------ 2
idiot ------ 2
low ------ 3
high ------ 4


I have searched for this question but all answers were not as i wanted.

Thanks in advance

Hi,

Assuming your data starts in cell A1, use this formula in B1

=COUNTIF($A$1:A1,A1)

and copy it down the length of your data.