Forum Discussion
VBA or Excel Formula?
I checked the Formulas tab, and "Show Formula" is NOT enabled.
I've attached my workbook for you look through at your convenience. There are 3 tabs and I'm having trouble on the "Cross Submit" tab getting the formula to "run."
Let me know if I can clarify anything for you.
Thank you!
Ronna
So, you are trying to duplicate Column D, but with a dynamic formula, right? There are a few hurdles here. First, on my side. I'm using Office 2016, and the TEXTJOIN function is not available to me. Second, Column D uses an array formula, you can tell by the {} around it. You don't actually key in the brackets, Excel automatically adds them when you enter the formula by pressing CTRL+SHIFT+ENTER. What you are trying to do, if possible, is well beyond my skill level. I apologize for taking up your time.