CODEWITHSUNDEEP
excel
Alex Gordon
Alex Gordon

Reputation: 60771

excel funny table syntax

what does this do?

=TABLE(,B5)

there is a table on the chart where every cell has a different value but in the formula it has that syntax above. every cell in the table has =TABLE(,B5) in it.

Upvotes: 2

Views: 358

Answers (2)

Mark Nold
Mark Nold

Reputation: 5698

TABLE() is used for scenarios via Data Tables.

Upvotes: 1

Jim Garrison
Jim Garrison

Reputation: 86774

Since it's not a valid builtin function, it must be a user-defined function.

Upvotes: 1

Related Questions