Assuming that A1:A10 contains names and B1:B10 contains some sort of
ailments, (with A1 being the header NAME and B1 being the header AILMENT)
you can easily summarize using a pivot table. Also assuming you're using
Excel 2007, perform the following steps:

1. Select any cell within A1:B10
2. Choose Insert-Pivottable.
3. Select OK to create the pivottable
4. Check both Name and Ailment in the field list box.
5. Drag Ailment down to the Values box in the lower right of the field list.

This will give you a pivot table showing each person, their ailments, and
the count of ailments.

From there, you can play around with the pivot and add formatting, remove or
add totals, etc.

Happy calculating!

If you like this answer, please click ''Yes.''




"grizzly6969" wrote:

I have on sheet 1 john -- sick
bill --- sick
john --- sick
ted ----- sick
john --- broken leg
is it possible to show on sheet 2 john - sick = 2
john - broken leg = 1
bill - sick = 1
etc. etc.
--
grizz