Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
what's wrong with this formula?
=offset(curbal,0,-1,1,1) I'm trying to get the data of the cell ON THE LEFT of the one named "Curbal" ie: a b c d 1 x Curbal 2 9 I don't know where is going to be located neither the name of the column the only thing I know its going to be on row 1 and is going to be on the left of the one named "Curbal" So in this example the number I want to get is 9 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Offset of a minumum | Excel Worksheet Functions | |||
Offset Function | Excel Worksheet Functions | |||
Offset Function | Excel Worksheet Functions | |||
Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
Question for use of offset and range | Excel Worksheet Functions |