If Then List Formula?
 

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!

If Then List Formula?
 

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


--
__________________________________
HTH

Bob

"BrittanyRuth" wrote in message
...
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!

If Then List Formula?
 

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.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"BrittanyRuth" wrote:

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!

If Then List Formula?
 

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.

"Shane Devenshire" wrote:

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.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"BrittanyRuth" wrote:

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!

If Then List Formula?
 

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...summary_table/

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

--
__________________________________
HTH

Bob

"BrittanyRuth" wrote in message
...
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.

"Shane Devenshire" wrote:

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.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"BrittanyRuth" wrote:

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!