Need Excel macro

Article View: net.micro.mac

Article #6646

#6646

From: Cheryl Nemeth
Date: Thu, 31 Jul 1986 06:48

22 lines
778 bytes

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?

Technical Details

Message-ID: <2027@calmasd.CALMA.UUCP>

Path: arc1-ca.pugleaf.net!utzoo!mnetor!seismo!caip!nike!ucbcad!ucbvax!sdcsvax!sdcc6!calmasd!cjn

Show Full Headers

Complete Article Headers

Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP
Path: arc1-ca.pugleaf.net!utzoo!mnetor!seismo!caip!nike!ucbcad!ucbvax!sdcsvax!sdcc6!calmasd!cjn
From: cjn@calmasd.CALMA.UUCP (Cheryl Nemeth)
Newsgroups: net.micro.mac
Subject: Need Excel macro
Message-ID: <2027@calmasd.CALMA.UUCP>
Date: Thu, 31-Jul-86 02:48:50 EDT
Article-I.D.: calmasd.2027
Posted: Thu Jul 31 02:48:50 1986
Date-Received: Fri, 1-Aug-86 03:22:38 EDT
Reply-To: cjn@calmasd.UUCP (Cheryl Nemeth)
Organization: G. E. CALMA R&D, San Diego, CA
Lines: 22