hi all - really annoyed i can't figure this one out in my head as i know it's in there somewhere, anyhow -
I want the column "Missing Elements" to concatenate all the missing elements, so either; vision, skill, incentive, resources, plan.
if the flag cell contains a "1" this means the element is present, a "0" means it is not - so the formula needs to go to each cell and return the corresponding value for each "0" and present these, concatenated, in the "missing elements" column. so, for the below, the first row would read "None" and the second row would read "Skill - Resources"
thanks in advance
I want the column "Missing Elements" to concatenate all the missing elements, so either; vision, skill, incentive, resources, plan.
if the flag cell contains a "1" this means the element is present, a "0" means it is not - so the formula needs to go to each cell and return the corresponding value for each "0" and present these, concatenated, in the "missing elements" column. so, for the below, the first row would read "None" and the second row would read "Skill - Resources"
Vision Flag | Skill Flag | Incentive Flag | Resources Flag | Plan Flag | Overall Change Score | Combined Change Profile | Missing Elements |
1 | 1 | 1 | 1 | 1 | 5 | CHANGE | |
1 | 0 | 1 | 0 | 1 | 3 | - - - - ANXIETY - - - FRUSTRATION - - |
thanks in advance