|
| 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
April 17th, 2004, 06:56 PM
|
|||
|
|||
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
April 17th, 2004, 07:01 PM
|
|||
|
|||
|
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
April 17th, 2004, 07:21 PM
|
|||
|
|||
|
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 | |
|
|
Linear Mode
