If Then List Formula?

[BrittanyRuth]

I have a sheet that lists multiple conferences. Across the top are possible
participants. Each participant marks their attendance to a specific
conference by a X.

I need to summarize each conference on another sheet with a list of
participants that have confirmed their attendance. I'm looking for sort of a
'If Then List' formula. Is this possible? Thanks!

 

[Bob Phillips]

Use a pivot table. See
http://www.contextures.com/xlPivot01.html

 

[Shane Devenshire]

Hi,

It doesn't sound to me as though you have a pivot table layout for your data
source. You haven't given us a lot of info regarding exactly what the
desired results look like.

Really you have the desired result on the first sheet just going
horizontally rather than vertically. At least that's what it sounds like.
Select the entire range on sheet1 and copy it. Selcect Sheet2 and choose
Edit, Paste Special, Transpose.

 

[BrittanyRuth]

I would like to avoid a pivot table if possible. I would like the end results
to be just a list of the names of people going.

 

[Bob Phillips]

I still say you could do it with a pivot, but if you really don't want one,
Walk shows a method to un-crosstab a table at
http://spreadsheetpage.com/index.php/tip/creating_a_database_table_from_a_summary_table/

It uses a pivot, but only as a staging post.