Forum Discussion
Refer to same Column in Table
- Mar 22, 2022
ClaudioGiovanoli Use this in stead:
=Table1[[uvw]:[uvw]]
Absolute Structured References in Excel Tables | Excel Campus
ClaudioGiovanoli Use this in stead:
=Table1[[uvw]:[uvw]]
Absolute Structured References in Excel Tables | Excel Campus
- ClaudioGiovanoliMar 22, 2022Copper Contributor
Thanks a lot, that worked.
Now I have two new issues:
First, how does the same work when I want to refer to a cell within the table? [@[uvw]]:[@[uvw]] doesn't seem to work
Second, since the header can't be repeated I want to concatenate in another Header. i.e. Conlumn Header: "Name1" -> new column header "Name1 alternative". Simply using "CONCATENATE" or & operators doesn't work
Best
- Riny_van_EekelenMar 22, 2022Platinum Contributor
ClaudioGiovanoli Use =Table1[@[uvw]:[uvw]] from both in- and outside the table.
Not sure what you mean with your second question. Can you upload a screenshot or share a file?
- ClaudioGiovanoliMar 22, 2022Copper Contributor
Thanks!
I want that in the right header the name of the left is included with some additional text