ranking Sort Sort   |   date Sort Sort   |   member Sort Sort
Syndication

5
Date Submitted Fri. Oct. 27th, 2006 8:30 AM
Revision 1
Helper RobHarrigan
Tags count | excel | group | macro | tally
Comments 0 comments
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