Hi
I'd suggest you store all your names in one column. After this you may
use a pivot table to generate the number of occurences for each unique
name

--
Regards
Frank Kabel
Frankfurt, Germany

"Jamie Allison" schrieb im
Newsbeitrag .. .
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.