Reference functions

[Joseph M. Yonek]

I have a table with a series of columns that a summary table is referencing.

In columns e,g,h,i,j,k,l there is a simple yes or no in each row of data.
On the summary page I would like to populate a cell referencing each of
those columns and in each cell that has a yes in it I would like the summary
page to return the column heading for all columns that have a yes.

What would be the best way to do that?

Thanks in advance.
Joe

 

[Jane]

You may want to do a COUNTIF function. For example, in
cell e4 on the summary page, you could put =COUNTIF
(TABLE_REFERENCE,"=yes"), where TABLE_REFERENCE is the
cells you're concerned with, such as E4:E100. This
formula will count the number of yes answers. If all you
want the cell to return is a "YES" if any of the cells is
yes, try =IF(COUNTIF(TABLE_REFERENCE,"=yes")>0,"YES","NO").

Jane

 

[Joseph M. Yonek]

Thanks Jane, but actually need to return the column heading not simply the
number of yes'.

 

[Guest]

Then try =IF(COUNTIF(TABLE_REFERENCE,"=yes")

0,HEADER_CELL,"") where HEADER_CELL is the location of

the column name you need returned. Be sure to anchor it
with $ ($A1) if you're copying the formula down.

Jane