if then statement to return text from cells satisfying condition

[Savvy]

HI, I need to check the contents of 29 columns and return the text
values of all the non-zero cells in that row.I am trying to run an if-
then statement to acheive the following:

if (B1:AD1 >1, (return the text within the cells as multiple strings
separated by commas),0)
I need help on how to acheive this result. I tried concatenation but
it wasn't working out.

Thanks

 

[Savvy]

I tried doing this and the resulting cell looks blank. Should I be
running any of the extra functions that I added in, for this to work?

 

[Savvy]

Thanks. It worked!

After you enter the formula, you need to hold the CTRL and SHIFT keys
down and then press ENTER.. You should see { } brackets appear around
the formula.. and the result should be visible in the cell.

Savvy;447518 Wrote:






--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile:http://www.thecodecage.com/forumz/member.php?userid=74
View this thread:http://www.thecodecage.com/forumz/showthread.php?t=123925- Hide quoted text -

- Show quoted text -