Equivalent to $A$1:A1 when anchoring in Data Table

[danhenshy23]

Hi,

When working with Data Tables how do you anchor the first cell in the row only?

This would be the equivalent to $A$1:A1

Thanks
Dan

 

[KOKOSEK]

Book1
	A	B	C	D	E
1	Header A	Header B	Header C
2	row 1 col 1	row 1 col 2	row 1 col 3		row 1 col 1
3	row 2 col 1	row 2 col 2	row 2 col 3		row 1 col 1
4	row 3 col 1	row 3 col 2	row 3 col 3
Sheet1

Cell Formulas
Range	Formula
E2	E2	=Table1[@[Header A]]
E3	E3	=A2

 

[Eric W]

How about:

Book1
	A	B	C
1	Date	Amount	YTD Amt
2	1-Jan	$ 10.00	$ 10.00
3	2-Jan	$ 20.00	$ 30.00
4	3-Jan	$ 30.00	$ 60.00
5	4-Jan	$ 40.00	$ 100.00
Sheet1

Cell Formulas
Range	Formula
C2:C5	C2	=SUM(INDEX([Amount],1):[@Amount])

 

[felixstraube]

I think one thing that works is, assuming the first data row is in A2:

$A$2:Table1[@[Header1]]