I am in need a formula that will look at multiple conditions for the data I have. My sample data is below. 

If the value in A is the same, and the value in B is the same, then join the values in C and put them in D. The formula I have for that function works (=IF(A2=A3, IF(A3=A4, TEXTJOIN(“,”,TRUE,C2,C3,C4),TEXTJOIN(“,”,TRUE,C2,C3)),””).

What I need the complete formula to do is this:

If the value in A is the same, and the value in B is the same, then join the values in C and put them in D, but if the value in A does not match, then copy the value from C2 to D2.

I hope I explained that well enough. I’m thinking it needs to be a nested formula, but I cannot figure it out. Any help will be greatly appreciated. 

​I am in need a formula that will look at multiple conditions for the data I have. My sample data is below. If the value in A is the same, and the value in B is the same, then join the values in C and put them in D. The formula I have for that function works (=IF(A2=A3, IF(A3=A4, TEXTJOIN(“,”,TRUE,C2,C3,C4),TEXTJOIN(“,”,TRUE,C2,C3)),””). What I need the complete formula to do is this:If the value in A is the same, and the value in B is the same, then join the values in C and put them in D, but if the value in A does not match, then copy the value from C2 to D2. I hope I explained that well enough. I’m thinking it needs to be a nested formula, but I cannot figure it out. Any help will be greatly appreciated.    Read More

​