Revison 1
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