[net.micro.mac] Need Excel macro

cjn@calmasd.CALMA.UUCP (Cheryl Nemeth) (07/31/86)

I need an Excel macro that will go down a list of items, eliminate duplicates,
and keep track of how many duplicates were removed.  Example

start list
a
a
b
b
b
b
c
d
e

end list
a	2
b	4
c	1
d	1
e	1

Anyone have something that will do this?