build a string from multiple fields

[jaykappy]

I have a blank field that I am trying to populate based off a bunch of other fields.
I have a bunhc of fields that either have a Yes or No in them....
I have about 200 rows to poulate.

1. I want to read each row and if the field is YES put the field name if NO then dont put anything there.
2. then read the next field and do the same
3. then read the next field and do the same etc.
4. then go to the NEXT row and do the same till the end of the file

Example Table in Excel... I am trying to build the string to put in the SpecDesc field
formula.jpg

I tried this and not working

I want the field SpecDesc to read as suc for every instance of YES in the field....an record nothing if its NO

Result to be put in SpecDesc Field
bat, beaver, bird etc


=IF(Y2="yes","bat,",IF(Y2="no","",""), IF(OR(Z2="yes","beaver,",IF(Z2="no","",""), IF(OR AA2="yes","bird,",IFAA2="no","","") )))

I then need to build this so it works on every ROW in the table...

Thoughts?

[AliGW]

Are you still using Excel 2007?

[jaykappy]

thanks for your reply...Office 2016

[jaykappy]

Im trying this but no go....trying to read a couple fields to build one string value

formula2.jpg

[jaykappy]

I got it with this


=CONCATENATE(IF(Y2="yes","bat,",""),IF(Z2="yes","beaver,",""))

[AliGW]

Please update your forum profile with your current Excel version.