I've been struggling with this for a full day and it is driving me insane. I am a new to this and I cannot get this formula to work for the life of me. I have a feeling it may be due to certain parenthesis, but not sure. I keep getting a VALUE!# error.
Formula: =TEXTJOIN(" , ",1,IF(AM2:AU2=AX2,AM1:AU1,""))
Recorded macro and got this: .FormulaR1C1 = "=TEXTJOIN("","",1,IF(RC[-12]:RC[-4]=RC[-1],R[-1]C[-12]:R[-1]C[-4],""""))"
The columns are dynamic or could change. I was trying to start with the basics and see if I could get any formula to work. Please help. I am lost.
Formula: =TEXTJOIN(" , ",1,IF(AM2:AU2=AX2,AM1:AU1,""))
Recorded macro and got this: .FormulaR1C1 = "=TEXTJOIN("","",1,IF(RC[-12]:RC[-4]=RC[-1],R[-1]C[-12]:R[-1]C[-4],""""))"
The columns are dynamic or could change. I was trying to start with the basics and see if I could get any formula to work. Please help. I am lost.