Unknown cell entry

**glennhong** · 09-17-2009, 07:35 AM

I am using a spreadsheet written by someone else that contains a type of cell entry I am not familiar with. These occur in several tables. The first 3 columns of each table contain numbers or basic formulas. These are followed by two columns in which every entry appears to be the following:

{=TABLE(,B33)}

Despite the same apparent "formula", the number displayed in each of these cells is different. If I click on the formula display box (to the right of the cell address box) to edit the "formula", the brackets disappear.

Can anyone tell me what sort of beast I am dealing with here?

**NBVC** · 09-17-2009, 07:44 AM

It looks like some sort of array user defined function...

http://www.cpearson.com/excel/ArrayFormulas.aspx

**sweep** · 09-17-2009, 07:55 AM

This is strange - it can't be a UDF - if you try and create a udf called table, you get a "function is not valid" error.

**NBVC** · 09-17-2009, 08:01 AM

You are likely right sweep,

Have a look here... at the bottom, Harlan Grove explains the phenomenon..

http://www.pcreview.co.uk/forums/thread-1750658.php

**glennhong** · 09-17-2009, 10:59 AM

The spreadsheet I am referring to may be found at:

http://biomass.ucdavis.edu/materials...r_Gasifier.xls

See cells E231:F251 for the "formula".

Thanks to all for considering....