LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CONCATENATE in Array formula Abhay Excel Discussion (Misc queries) 6 January 17th 08 10:38 AM
Array Formula with Concatenate and If Kris_Wright_77 Excel Worksheet Functions 2 September 29th 06 04:24 PM
Concatenate an array Ed Excel Discussion (Misc queries) 4 July 3rd 06 05:57 PM
Concatenate Multiple Instances in Array sunfish62 Excel Worksheet Functions 1 June 24th 05 04:56 AM
How do I concatenate the contents of an array in Excel? Johnnie Walker Excel Worksheet Functions 0 February 16th 05 10:11 AM


All times are GMT +1. The time now is 09:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"