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,
..

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


"Just Some Nobody" <Just Some wrote in
message ...
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,
.

Thanks ... good pointer.

"Roger Govier" wrote:

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


"Just Some Nobody" <Just Some wrote in
message ...
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,
.

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" wrote:

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,
.

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!!

"Shweta Srivastava77" wrote:

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" wrote:

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,
.