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

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

I'm sorry, i didnt include the fact that i wanted to move the persons name to
another list, perhaps on a different sheet. If Joe Public took painting as
#1, sculpting as #2, writing as #3, then i want a list to show all those who
chose #1, #2 and then #3. I have the IFCOUNT at the bottom, but would like
to separate the names along with it. Hopefully that makes sense. Also there
is how the data is set up:

Names: B5 - B71
Activity Names: J3 - N3, O3 - T3, U3 - Y3 (three different sessions)

Thank you for your input


"Art Farrell" wrote:

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

From your description it looks like you want a separate sheet for each
activity with columns for the five choices and a list of names in the
columns depending on the selection. I think a macro based on autofiltering
could work. If that's what you want it would be better to send me a copy of
your worksheet so I could set it up with the macro.

Send to:

CHORDially,
Art Farrell

"E Savard" wrote in message
...
I'm sorry, i didnt include the fact that i wanted to move the persons name
to
another list, perhaps on a different sheet. If Joe Public took painting
as
#1, sculpting as #2, writing as #3, then i want a list to show all those
who
chose #1, #2 and then #3. I have the IFCOUNT at the bottom, but would
like
to separate the names along with it. Hopefully that makes sense. Also
there
is how the data is set up:

Names: B5 - B71
Activity Names: J3 - N3, O3 - T3, U3 - Y3 (three different sessions)

Thank you for your input


"Art Farrell" wrote:

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