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