I need to create a workbook summary sheet. Help.

[ashagape]

I have a large collection of data and I need to pull some of it for a summary. Right now, if there is an X in a cell I have it putting the column heading in the summary.
=IF (A3="X", A1, " ")
=IF (B3="X", B1, " ")
=IF (C3="X", C1, " ")
etc.

I have this done for multiple rows. My summaries are getting too large. Is there a way to collect all of the data into one cell? I would like the end result in the cell to have the column headings all listed out: A1, B1, C1

Thanks.

 

[jeffreybrown]

You should keep to the original thread.

http://www.mrexcel.com/forum/showthread.php?t=377879