View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
janmomx3 janmomx3 is offline
external usenet poster
 
Posts: 1
Default Array formula & Concatenate

I am in need of summarizing responses to questions based on the respondent
marking their selection in column A with an X. I am assuming that an array
formula would do it for me. I want to concatenate the responses selected in
column A into column C (any row), not include any blanks (choices not
selected with the X) and separate each response with a comma. So it would
look like this: small group, tutorial, one on one training. Is an array
formula what I need? If so, how would I write it?

TIA for your help
janmomx3

A B C
1 large group
2 X small group
3 X tutorial
4 Modeling by a trainer
5 X one on one training
6 other