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.
- I want to read each row and if the field is YES put the field name if NO then dont put anything there.
- then read the next field and do the same
- then read the next field and do the same etc.
- 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?
Bookmarks