byteMyCode: Snippet Revisions http://www.bytemycode.com Revisions for this snippet. Thu, 21 Aug 2008 23:07:10 +0000 1998-2008 en-us http://www.bytemycode.com http://www.bytemycode.com/img/rss_title.gif byteMyCode Group and count items in Excel 1 http://www.bytemycode.com/snippets/snippet/492/1/ http://www.bytemycode.com/snippets/snippet/492/comments/ Fri, 27 Oct 2006 08:30:38 +0000 RobHarrigan count, excel, group, macro, tally http://www.bytemycode.com/snippets/snippet/492/ Excel macro to group and count the number of items in a range of cells, delimited by the pipe character "|". It returns a summary of the items including a percent of total and count for each item found, plus a grand total of all items.

Currently limited to 100 items, simple becasue I didn't have the time to spend to get dynamic arrays to work.


Sample Data:
--------------
cat|dog|bird
--------------
cat|bird
--------------
cat
--------------
frog

==================
OUTPUT from =total(A1:A4)
==================
42.9% - 3: cat
28.6% - 2: bird
14.3% - 1: dog
14.3% - 1: frog
---
7

]]>