Forum Discussion
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 ...
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.