If cell text changes, increase value by 1?

[JJ2k10]

Could someone help me out please? Say There's a column of data in column A like this:

Helmet
Helmet
Helmet
Helmet
Helmet
Bike
Helmet
Gloves
Computer
Computer

then I would like the column next to it change accordingly like this;


Helmet 1
Helmet 1
Helmet 1
Helmet 1
Helmet 1
Bike 2
Helmet 3
Gloves 3
Computer 4
Computer 4



How would I do this? Thanks.

[stnkynts]

Try:

Please Login or Register  to view this content.