LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
array formula question Gary Keramidas Excel Programming 4 April 15th 08 03:38 AM
Array Formula Question IPerlovsky Excel Worksheet Functions 6 March 10th 07 05:04 AM
Array Formula question nicgendron[_10_] Excel Programming 2 August 19th 05 03:15 PM
SUM array formula question Dan Excel Worksheet Functions 6 November 8th 04 05:49 AM
Array Formula Question Don Wiss Excel Programming 1 December 19th 03 05:09 AM


All times are GMT +1. The time now is 04:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"