Forum Discussion
VBA or Excel Formula?
Ronna,
If I understand correctly, you have a cell that you have entered =(B30&B31&B32), and when you press enter, instead of showing the result, it continues to display the formula. It's likely that the cell is formatted as text. If you change it to General, then click in the formula bar or double click the cell, then press enter, does it resolve your issue?
Bob, thanks for your response. I tried your suggestion of making the cells as "general" and not "text" and it didn't work. :(
Any other ideas are welcome!
Thanks,
Ronna
My other thought would be on the Formulas tab, ensure that Show Formulas is not enabled. Beyond those two possibilities, I would need to see a 'sanitized' version of your file, without any personal or sensitive information, to see what might be going on. If you could post a copy, I might be able to assist a little better.
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
- This array formula seems to return an array of the numbers you are looking for, wrapping it in a TextJoin should work:
=IFERROR(INDEX(CandTable[jobOrderID],SMALL(IF(CandTable[candidateID]=$B$3,ROW(CandTable[candidateID]),""),ROW(CandTable[candidateID])-ROW(CandTable[[#Headers],[candidateID]]))),"")
