Strage function in worksheet {=TABLE(I64,)}

M

mkadon

I am attempting to understand what appears to be a custom function in a
workbook I was given, author unknown. It seems to be some type of index or
look up but their is no help on it or macro defined for it.

has anyone used or familiar with this? If you need more information I would
be happy to provide it.

{=TABLE(I64,)}

Thanks,
Mark
 
R

Ron Rosenfeld

I am attempting to understand what appears to be a custom function in a
workbook I was given, author unknown. It seems to be some type of index or
look up but their is no help on it or macro defined for it.

has anyone used or familiar with this? If you need more information I would
be happy to provide it.

{=TABLE(I64,)}

Thanks,
Mark
Click to expand...

I believe that was a macro function for Excel 4 macro sheets (and perhaps other
versions also). I think the function, as written, defines I64 as the row input
for the table.


--ron
 
M

Mark

Hello, thanks for your insight, you obviously know spreadsheets very
well. I am still a novice and don't completely understand your
observation.

Would you mind expanding on your answer a bit further.

"The cells in the column immediately to the left of the array of cells
containing the TABLE call contain the formula(s) applied by TABLE to
the values in the row immediately above this array of cells."
{=Table(E63,E64)}

I take it the TABLE call in this example is E63 and E64? I am not
able to find the formula you referred to?

This is a tough one for me! I guess I need it explained in a fashion
for a true beginner!

Thank you for your time and assistance.
Mark
 
R

Ron Rosenfeld

Hello, thanks for your insight, you obviously know spreadsheets very
well. I am still a novice and don't completely understand your
observation.

Would you mind expanding on your answer a bit further.

"The cells in the column immediately to the left of the array of cells
containing the TABLE call contain the formula(s) applied by TABLE to
the values in the row immediately above this array of cells."
{=Table(E63,E64)}

I take it the TABLE call in this example is E63 and E64? I am not
able to find the formula you referred to?

This is a tough one for me! I guess I need it explained in a fashion
for a true beginner!

Thank you for your time and assistance.
Mark
Click to expand...

Mark,

Based on what you have written and the exact format of the formula, it seems as
if you are looking at a regular worksheet (and not a macro sheet as I had
originally thought) in a release later than XL4.

If that is the case, look up DATA TABLE in HELP, and that should give you a
good start.


--ron
 
T

Tushar Mehta

I don't know how the Data | Table capability is implemented (i.e.,
whether it uses an implicit XLM macro), but the =TABLE(...) array
function is a result of creating a one-way or a two-day table.

For more on the capability look up 'data table' (w/o the quotes) in XL
help. You'll find a bunch of topics such as 'About data tables' or
'Create a two-variable data table' or 'Create a one-variable data
table'

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Top