Comparing Data

  • Thread starter Thread starter Jamie Allison
  • Start date Start date
J

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.
 
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
 
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.
 
Back
Top