Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

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.

 

thanks

 

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.