adding tables and sheets - how can these be used?

i see can add tables , sheets reposnse table possible use newly created tables , sheets perfom analysis on respisne table?

 

not sure how tables , sheets supposed used.

 

thanks,

derek

yes, possible use additional tables, whether on same sheet or on additional sheets, perform analysis on response table.  there several ways refer response table other tables:

 

='response table'!'first name'

 

refers column called "first name" in response table.  single quotes needed if name contains spaces or other special characters.  variant of is

 

='response table'!b

 

which refers column denoted letter b above column name.  in both of above cases, there implicit correlation between row number in response table , row number in new table.  if wish refer specific cell in response table, can use familiar syntax accessing cells, in row being referred explicitly defined:

 

='response table'!b2

='response table'!$b$2

 

you can build formulas using these references.  may use summary functions refer entire column using @ syntax, example:

 

=average('response table'!@age)

 

hope helps,

 

eylon

More discussions in Archived Spaces

adobe