If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding an Offset to a Column Value
I often have a formula executing on one sheet referring to
data on another sheet. My problem is that, while I can determine the column letter of one column, I don't know a clean way to apecify the column letter that is, say, 2 columns over from the column I start with. In other words, I want to add a column offset to a known column letter, but letters don't add well. If I use the Column function, it returns a number, not a letter. I can add the offset to that number, but then I can't get the letter equivalent to the result. How do you convert a column number into a column letter?? |
#2
|
|||
|
|||
Adding an Offset to a Column Value
Hi
try something like =OFFSET($A$1,0,3) to get the value from D1 -- Regards Frank Kabel Frankfurt, Germany SidBord wrote: I often have a formula executing on one sheet referring to data on another sheet. My problem is that, while I can determine the column letter of one column, I don't know a clean way to apecify the column letter that is, say, 2 columns over from the column I start with. In other words, I want to add a column offset to a known column letter, but letters don't add well. If I use the Column function, it returns a number, not a letter. I can add the offset to that number, but then I can't get the letter equivalent to the result. How do you convert a column number into a column letter?? |
#3
|
|||
|
|||
Adding an Offset to a Column Value
Thanx, Frank. I knew there had to be something simple.
-----Original Message----- Hi try something like =OFFSET($A$1,0,3) to get the value from D1 -- Regards Frank Kabel Frankfurt, Germany SidBord wrote: I often have a formula executing on one sheet referring to data on another sheet. My problem is that, while I can determine the column letter of one column, I don't know a clean way to apecify the column letter that is, say, 2 columns over from the column I start with. In other words, I want to add a column offset to a known column letter, but letters don't add well. If I use the Column function, it returns a number, not a letter. I can add the offset to that number, but then I can't get the letter equivalent to the result. How do you convert a column number into a column letter?? . |
Thread Tools | |
Display Modes | |
|
|