I have a series of if/then conditions I need to concatenate... Rather than have a long formula of concatenate(if(a2="fail",a1,""),if(b2="fail",b1,""),......) I would like to do an array formula {=Concatenate(if(A2:R2="Fail",$C$1:$R$1,""))} Unfortunately concatenate only sees the first result in the array... When I evaluate the if then portion, I get {"","",Cell$C$1,"",""...) but the concatenation will not joint them together. I tested this by using the formula {=concatenate({"Yes","No"})} and got Yes as my answer...
Any ideas how to make this work the way I want?
Thanks,
CN.
Any ideas how to make this work the way I want?
Thanks,
CN.