Oct 25 2023 03:08 AM
Hi,
I'm just wondering if there's a cleaver way to reference a table column when using CHOOSECOLS(Table1,COLUMN(Table1[data])) when the table isn't in column A of the sheet without having to do COLUMN(...)-1 or refer to cell above the table that has a COLUMN() in it?
In other words, is there a native formula that returns the column/row position of a table column/row relative to the table itself?
Oct 25 2023 04:21 AM - edited Oct 25 2023 04:24 AM
Not to be pedantic, but doesn't this:
=CHOOSECOLS(Table1,COLUMN(Table1[data]))
return the same as:
=Table1[data]
Perhaps this: =CHOOSECOLS(Table1,MATCH("Data",Table1[#Headers],0))
Oct 25 2023 07:27 AM
Oct 26 2023 02:01 AM