Hi

I have come across a spreadsheet with the following formula in it

{=TABLE(J88,G88)}

i know that this is some sort of array formula because of the {} brackets,
however i cannot get this to work outside the file i have been sent.

there is no Help about this in Excel & when i try to Ctrl+Shift+Enter into a
new cell, looking up the same cell references, it fails to work, saying "This
formula is not valid"?

Is 'TABLE' a bespoke formula of some kind?

Do i need some special Add-In enabled? I have both the Analysis Paks turned
on?

Any help gratfeully recieved, let me know if you need anymore info

cheers

jb

Hi jb,

The 'TABLE' function is not a standard Excel function, but rather a custom function that has been created using VBA (Visual Basic for Applications) code. This is why you are not able to get it to work outside of the file you were sent.

To use this function, you would need to have the VBA code that creates the function available in your Excel workbook. This could be in the form of an

1. add-in or
2. macro-enabled workbook

that you would need to open and enable in order to use the function.

Without access to the VBA code, it is not possible to recreate the 'TABLE' function in a new workbook. If you need to use this function, you will need to obtain the original file or contact the person who created it to get more information on how to use it.

I hope this helps clarify things for you. Let me know if you have any other questions!

Hi

I have just found a very good response to a similar question from Max in
Singapore,

thank you Max!!!

"JB2010" wrote:

Hi

I have come across a spreadsheet with the following formula in it

{=TABLE(J88,G88)}

i know that this is some sort of array formula because of the {} brackets,
however i cannot get this to work outside the file i have been sent.

there is no Help about this in Excel & when i try to Ctrl+Shift+Enter into a
new cell, looking up the same cell references, it fails to work, saying "This
formula is not valid"?

Is 'TABLE' a bespoke formula of some kind?

Do i need some special Add-In enabled? I have both the Analysis Paks turned
on?

Any help gratfeully recieved, let me know if you need anymore info

cheers

jb

You're welcome <g !
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400 Files:358 Subscribers:55
xdemechanik
---
"JB2010" wrote:
I have just found a very good response to a similar question from Max in
Singapore,

thank you Max!!!

So what was the answer?

"JB2010" wrote:

Hi

I have just found a very good response to a similar question from Max in
Singapore,

thank you Max!!!

"JB2010" wrote:

Hi

I have come across a spreadsheet with the following formula in it

{=TABLE(J88,G88)}

i know that this is some sort of array formula because of the {} brackets,
however i cannot get this to work outside the file i have been sent.

there is no Help about this in Excel & when i try to Ctrl+Shift+Enter into a
new cell, looking up the same cell references, it fails to work, saying "This
formula is not valid"?

Is 'TABLE' a bespoke formula of some kind?

Do i need some special Add-In enabled? I have both the Analysis Paks turned
on?

Any help gratfeully recieved, let me know if you need anymore info

cheers

jb

So what was the answer?

{=TABLE(J88,G88)}

That's in a 2 variable data table, which is used to quickly produce
what-if-tables based on 2 variables, in sensitivity analysis. And albeit it
looks very much like an array formula, it cannot be entered as such. It has
to be set-up via the menu command: Data Table.

Try typing in Excel's help: two variable data table
for more information

Try also the 2* samples on data table in my archives:
*one variable, 2 variable

One variable data table example.xls
http://savefile.com/files/1007074

2 variable data table example.xls
http://savefile.com/files/46276

The samples contain the construct steps
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
---