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

[witcomm]

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