Forum Discussion
Solved
TEXTJOIN/Nested IF error
Ok, So I’m almost complete with this simple excel database I created to help make my job more efficient. The only issue I am running into is creating an accurate TEXTJOIN function. The conditions and...
I guess you are on an old version of Excel. Since this is an array formula you have to use the magic keystroke CRTL-SHIFT-ENTER.
I guess you are on an old version of Excel. Since this is an array formula you have to use the magic keystroke CRTL-SHIFT-ENTER.
Thank You,
Not how I expected but the CRTL-SHIFT-ETR function did work. Apparently something I hadn't know is Excel will not allow you to enter an array formula over merged cells. This is certainly helpful for the time being though, Thank you!
Not how I expected but the CRTL-SHIFT-ETR function did work. Apparently something I hadn't know is Excel will not allow you to enter an array formula over merged cells. This is certainly helpful for the time being though, Thank you!