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.
=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.