having issues with a array formula.

Copper Contributor

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.




2 Replies

@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.