Hi,
I have multiple named columns in a worksheet(a, b,c). I want to use data from either of these columns to create new data. Is there anyway I can put the name of the column I want to use in a cell and refer to the cell's content to identify the column i want to use? e.g i want to use data from column a, so I put some cell $C1 = a. And in a formula, I want to be able to get max(column name referred to in $C1).
i tried CELL, defined cells etc. Didnt work!
anybody know how to do this?
thx
dpk
I have multiple named columns in a worksheet(a, b,c). I want to use data from either of these columns to create new data. Is there anyway I can put the name of the column I want to use in a cell and refer to the cell's content to identify the column i want to use? e.g i want to use data from column a, so I put some cell $C1 = a. And in a formula, I want to be able to get max(column name referred to in $C1).
i tried CELL, defined cells etc. Didnt work!
anybody know how to do this?
thx
dpk