Comparing Data

[Jamie Allison]

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.

 

[Frank Kabel]

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

 

[Dave Peterson]

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.