Good Morning:

I have a column that was use for inventory control. I want to subtotal that
column and delete its duplicates.

example:

abc
abc
def
def
def

I want column b to give me the count for each repetive cell and then delete
the duplitates. The result should be:

abc 2
def 3

Please help.

Thank you.

PaolaAndrea