having issues with a array formula.

[cbishop395]

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]

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

[#3]

@cbishop395 

Could it be What-if-analysis with datatable?

https://support.microsoft.com/en-us/office/calculate-multiple-results-by-using-a-data-table-in-excel...