TABLE function - where in Mac Office

[MattD]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I used the TABLE function in Office when I was on a PC (not pivot table) and it is not recognized in Mac Office. Does anyone know where I can find it or use it under a different name?

 

[CyberTaz]

Hello Matt -

I'm not sure what you're looking for as there is no TABLE *function* in any
version of Excel. My best guess is that you're referring to the Table
*feature* available on the Insert Tab in Excel 2008, which is simply a
"dressed up" version of the List feature in 2003.

If that's what you mean, Yes, the List Manager feature is available in Excel
2008. Select the data range for your list then go to Insert> List. The
dialog will walk you through some options. There is also a List Toolbar
which works in conjunction with the List once it's created.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Mike Middleton]

MattD -

The TABLE array function can be entered only by choosing Data | Table.

As far as I know, it works the same on Windows and Mac versions of Excel.

And, I just checked, it works fine with Mac Excel 2008.

If you're interested in some step-by-step instructions, download the
"Sensitivity Analysis Using Excel" pdf file from the Chapters page at
www.treeplan.com.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[Pat McMillan]

I believe Matt is looking for the Table feature that exists in Windows Excel
2007. If so, it is not available in Mac Excel. It's similar to, but not the
same as the List Manager feature in Mac Excel. We're hoping to add full
support for Tables (similar to what's available in Windows Excel) in a
future version.

Thanks,

Pat