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