How to deal with {=TABLE(A216,B216)}?

the {} means it is an array formula. Table seems to be a custom function, or at least one I do not have installed. It seems to be defining a table. So, logically {=TABLE(A2,B216)} returns an array with the data within the defined range. Changing the cell addresses will enlarge or shrink the table.

This function would almost certianly have to be used in conjunction with some other function to return a value, since this would not be displayable in a single cell.

That is a Data Table reference:

see here:

http://support.microsoft.com/kb/282852

then click some of the links in the references to see other examples.


You can also google for: "data table" excel

and see other related information and examples.