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.

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.

I like Frank's suggestion of a pivottable, but if you know the exact names that
can occur in your table of names, you can use:

=countif(a1:g9999,"Jo")
=countif(a1:g9999,"Frank")
and so forth.



Jamie Allison wrote:

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.

--

Dave Peterson