Hi All Gurus,
I did try with generic if and concatenate i am not getting the results as per the requirement, it only gives me Single Answer not for concatenate
I was trying to do multiple if with concatenate unforunately not getting what i am looking for .
I want where there is a Yes in Cell Headers Sould be populate as a result
A2= Yes , B2=Yes, C2= No, D2=No Rule1, Rule2 ( because A= is Yes and b2 is Yes )
A2A=Yes b2= No, C2=Yes, D2=Yes Rule1, Rule3, Rule4 ( becuase A,B, D has Yes )
Thank You For the help
I did try with generic if and concatenate i am not getting the results as per the requirement, it only gives me Single Answer not for concatenate
I was trying to do multiple if with concatenate unforunately not getting what i am looking for .
I want where there is a Yes in Cell Headers Sould be populate as a result
A2= Yes , B2=Yes, C2= No, D2=No Rule1, Rule2 ( because A= is Yes and b2 is Yes )
A2A=Yes b2= No, C2=Yes, D2=Yes Rule1, Rule3, Rule4 ( becuase A,B, D has Yes )
Thank You For the help