Excel 2007 Tables

[Just Some Nobody]

Perhaps i'm missing something.
But it seems very strange to me that you can't specify a "header column" in
excel tables and index by row. The only row index possible is [#This Row].
Someone please tell me i'm missing something very simple.

Thanks,
..

 

[Roger Govier]

Hi

Try
=INDEX(Table1[ColumnHeaderName],5)

will give the value in row 6 for the column name specified,
When you create the Table, it knows that Row 1 is header information,
and the Table data starts from row 2

 

[Shweta Srivastava77]

Not able to get the question clearly?? Is it about repeatiton of column/row
heading in every page or something related to Headers/Footers??

Shweta Srivastava.

 

[Just Some Nobody]

Thanks ... good pointer.

Hi

Try
=INDEX(Table1[ColumnHeaderName],5)

will give the value in row 6 for the column name specified,
When you create the Table, it knows that Row 1 is header information,
and the Table data starts from row 2

--
Regards

Roger Govier

Perhaps i'm missing something.
But it seems very strange to me that you can't specify a "header
column" in
excel tables and index by row. The only row index possible is [#This
Row].
Someone please tell me i'm missing something very simple.

Thanks,
.

 

[Just Some Nobody]

It's related to table references.

Table ::

TopLeft Column1 Column2 Column3
Row1 1 2 3
Row2 4 5 6
Row3 7 8 9

I can say MyTable[Column1] to get the range 1,4,7 but i can't say
MyTable[Row1] to get 1,2,3

Very annoying!!

Not able to get the question clearly?? Is it about repeatiton of column/row
heading in every page or something related to Headers/Footers??

Shweta Srivastava.

Perhaps i'm missing something.
But it seems very strange to me that you can't specify a "header column" in
excel tables and index by row. The only row index possible is [#This Row].
Someone please tell me i'm missing something very simple.

Thanks,
.