hi expert..

i have problem about counting data based on adjacent cell (data2) & the result moving up (on a line), like this below ;

data1----------data2---------desired result
baby-----------clothes---------2
------------shower--------
man------------paper----------1
girl-------------love------------3
-------------notebook------
-------------fish-----------
etc...

any help me, will be appreciated..

thanks...

john m..