| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to replace column letter in refferences with a function using the old column letter?
Hello
How to replace column letter(s) (or column numbers) in refferences with a result of a function using the old column letter(s) (or column numbers)? |
|
#2
|
|||
|
|||
|
I think you mean
=INDIRECT(A1&7) where A1 holds the letter in this instance. -- HTH Bob Phillips "Dmitry Kopnichev" wrote in message ... Hello How to replace column letter(s) (or column numbers) in refferences with a result of a function using the old column letter(s) (or column numbers)? |
|
#3
|
|||
|
|||
|
Thanks for your reply.
How to change =C1 (any reference) to =INDIRECT(A1&1(the same row number) automatically? "Bob Phillips" сообщил/сообщила в новостях следующее: ... I think you mean =INDIRECT(A1&7) where A1 holds the letter in this instance. -- HTH Bob Phillips "Dmitry Kopnichev" wrote in message ... Hello How to replace column letter(s) (or column numbers) in refferences with a result of a function using the old column letter(s) (or column numbers)? |
|
#4
|
|||
|
|||
|
=INDIRECT(A1&ROW())
-- HTH Bob Phillips "Dmitry Kopnichev" wrote in message ... Thanks for your reply. How to change =C1 (any reference) to =INDIRECT(A1&1(the same row number) automatically? "Bob Phillips" сообщил/сообщила в новостях следующее: ... I think you mean =INDIRECT(A1&7) where A1 holds the letter in this instance. -- HTH Bob Phillips "Dmitry Kopnichev" wrote in message ... Hello How to replace column letter(s) (or column numbers) in refferences with a result of a function using the old column letter(s) (or column numbers)? |
|
#5
|
|||
|
|||
|
Thanks!
How to convert a column number to a corresponding column label, letter? "Bob Phillips" сообщил/сообщила в новостях следующее: ... =INDIRECT(A1&ROW()) -- HTH Bob Phillips "Dmitry Kopnichev" wrote in message ... Thanks for your reply. How to change =C1 (any reference) to =INDIRECT(A1&1(the same row number) automatically? "Bob Phillips" сообщил/сообщила в новостях следующее: ... I think you mean =INDIRECT(A1&7) where A1 holds the letter in this instance. -- HTH Bob Phillips "Dmitry Kopnichev" wrote in message ... Hello How to replace column letter(s) (or column numbers) in refferences with a result of a function using the old column letter(s) (or column numbers)? |
|
#6
|
|||
|
|||
|
I use a simple UDF
'----------------------------------------------------------------- Function ColumnLetter(Col As Long) '----------------------------------------------------------------- Dim sColumn As String sColumn = Split(Columns(Col).Address(, False), ":")(1) ColumnLetter = sColumn End Function -- HTH Bob Phillips "Dmitry Kopnichev" wrote in message ... Thanks! How to convert a column number to a corresponding column label, letter? "Bob Phillips" сообщил/сообщила в новостях следующее: ... =INDIRECT(A1&ROW()) -- HTH Bob Phillips "Dmitry Kopnichev" wrote in message ... Thanks for your reply. How to change =C1 (any reference) to =INDIRECT(A1&1(the same row number) automatically? "Bob Phillips" сообщил/сообщила в новостях следующее: ... I think you mean =INDIRECT(A1&7) where A1 holds the letter in this instance. -- HTH Bob Phillips "Dmitry Kopnichev" wrote in message ... Hello How to replace column letter(s) (or column numbers) in refferences with a result of a function using the old column letter(s) (or column numbers)? |
|
#7
|
|||
|
|||
|
Thanks.
I have to make a 2004 year calculation using 2004 year table in the same way a 2003 year calculation which used 2003 year table was made. I copied formulas from 2003 version table to 2004 version table. The 2004 version table has different columns order therefore column letters in the formulas are incorrect. I want to change the column letters to correct ones according to 2003 and 2004 column lables located in a top row in the tables. I have to use columns with the same lables as in 2003 year in formulas. How to change the column letters to correct ones in all cells automatically? I do not need to change row numbers because they are correct. "Bob Phillips" сообщил/сообщила в новостях следующее: ... I use a simple UDF '----------------------------------------------------------------- Function ColumnLetter(Col As Long) '----------------------------------------------------------------- Dim sColumn As String sColumn = Split(Columns(Col).Address(, False), ":")(1) ColumnLetter = sColumn End Function -- HTH Bob Phillips "Dmitry Kopnichev" wrote in message ... Thanks! How to convert a column number to a corresponding column label, letter? "Bob Phillips" сообщил/сообщила в новостях следующее: ... =INDIRECT(A1&ROW()) -- HTH Bob Phillips "Dmitry Kopnichev" wrote in message ... Thanks for your reply. How to change =C1 (any reference) to =INDIRECT(A1&1(the same row number) automatically? "Bob Phillips" сообщил/сообщила в новостях следующее: ... I think you mean =INDIRECT(A1&7) where A1 holds the letter in this instance. -- HTH Bob Phillips "Dmitry Kopnichev" wrote in message ... Hello How to replace column letter(s) (or column numbers) in refferences with a result of a function using the old column letter(s) (or column numbers)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running total w/2 columns - Excel | Excel Worksheet Functions | |||
| What will cause column headings to change from letter to number? | Excel Discussion (Misc queries) | |||
| How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
| Excel: How do I type a letter in a column and make a check mark a. | Excel Worksheet Functions | |||
| How can I sort an entire spreadsheet from a list | Excel Worksheet Functions | |||
Linear Mode
