Hi All,

Think this is probably an easy question but I just can't seem to figure out
how to do it.

I have 7 columns of data see example below. I want to compare the data in
each column and come up with a separate list of all the names and how many
time they occur.

Column 1 Column 2 Column 3 Column 4 Column 5 Column 6 Column 7
Jo Ben Ben Jo Frank Henry Jo
Ben Frank Henry Marge Frank Ben
Henry Frank Frank
Frank


Such as a list now saying

Jo 3
Ben 4
Henry 3
Frank 6
Marge 1

I have around 200 items in each column but not each column has them all in
the same order or same amount of items.

Any help would be appreciated.

Thanks.