Hi,

Assuming your table has the names in Column A and the 5 activities in B
through F make another list in say Columns H through M with the numbers 1 to
5 in H and the activities across the top. Then in I2 put the formula:

=COUNTIF(B$2:B$100,(ROW())-1)

This assumes the formula is in I2. If it's in another row you want to have
( row number - x =1). Click on the right hand cell corner and drag down four
rows. Select the five formulas and click on the lower right corner and drag
across the four columns. This will give you the total of first choices,
etc., in each activity.

CHORDially,
Art Farrell


"E Savard" wrote in message
...
I have a worksheet in which there are several columns that relate to
activites people can participate in. For each person, they have filled in
their preference with a 1 - 5 scale. I now want to isolate each choice,
is
this possible? I have tried a few different methods and just cant seem to
get it to work