using Table function in array formula

gp2012

New Member
Joined
Jan 11, 2013
Messages
27
Hi,

I inherited an Excel with a scenario table (one variable by other variable) and a sensitivity table that comes with it. The sensitivity table seems to be created via a formula that looks like {=table(X variable, Y variable)}. When I try to copy the sensitivity table to a new sheet it only copies the values. When I try to copy the table by re-writing the exact formula I get the error that table isn't a function and it won't let me do it.

Any idea on what I can do to replicate the sensitivity data table?
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Dave Patton

Well-known Member
Joined
Feb 15, 2002
Messages
4,033
Office Version
2010
Platform
Windows
You may be referring to a feature of Excel

look in Data | What-if-Analysis | Data Table

or search for information on using a Data Table
 

Watch MrExcel Video

Forum statistics

Threads
1,099,462
Messages
5,468,786
Members
406,608
Latest member
G3TEN

This Week's Hot Topics

Top