View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael[_4_] Michael[_4_] is offline
external usenet poster
 
Posts: 27
Default array formula question

Someone sent me a workbook with a table of cells that all have the
following fomula in it:

{=TABLE(,B23)}


Table is not a named range and each cell returns a different value
eventhough they all reference B23. B23 has a constant value in it.

I know the {} mean it is an array but cant figure out what TABLE and
(,B23) mean or do.