Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet function to refer to columns by number
Is there a worksheet function where I can refer to the cell by row and column
number rather than having to refer to columns by letters. For example I want to use a formula like +cellvalue(1,1) rather than +a1. I need to be able to increment the column and I don't know how to increment letters of the alphabet. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet function to refer to columns by number
When you say increment the Column letters how do you intend on doing this?
Often Excel will increment for you depending on what you want to do. Can you give us an example of how you want to increment things? "mcambrose" wrote: Is there a worksheet function where I can refer to the cell by row and column number rather than having to refer to columns by letters. For example I want to use a formula like +cellvalue(1,1) rather than +a1. I need to be able to increment the column and I don't know how to increment letters of the alphabet. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling Data off Web - Need Function Help | Excel Worksheet Functions | |||
numerical integration | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
How do you extend the number of blank columns in a worksheet? | Excel Worksheet Functions | |||
Looking for function or formula to calculate number that is revers | Excel Worksheet Functions |