Forum Discussion
cbishop395
Nov 22, 2023Copper Contributor
having issues with a array formula.
WHen i type my formula It needs to have {} around it i believe this is an array formula. I'm using =Table(,G101) and no matter what i do CMD+shft+enter it text wraps to another line and wont add the {} in front and back of the code
please help.
thanks
- Riny_van_EekelenPlatinum Contributor
cbishop395 Not sure what you have in mind with =Table(,G101). The comma seems out of place and not sure what =Table(G101) should achieve either.
Anyway, if you intend to enter an array formula you should use Ctrl-Shift-Enter. Not Cmd-Shift-Enter. Are you on a Mac by any chance?
Please share a file (Onedrive or similar) or at least some screenshots that demonstrate your intentions.
- Detlef_LewinSilver Contributor
Could it be What-if-analysis with datatable?