Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula and offset
in a formulate, how do I get the value on the cell 1 column to left, and
next row? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula and offset
Hit:
The "equals" sign The "left arrow" key The "down arrow" key The "enter" key __________________________________________________ ____________________ "GS" wrote in message ... in a formulate, how do I get the value on the cell 1 column to left, and next row? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula and offset
if the cell in question is C2, try
=OFFSET(C2,1,-1) "GS" wrote: in a formulate, how do I get the value on the cell 1 column to left, and next row? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Offset Formula | Excel Worksheet Functions | |||
Offset formula | Excel Worksheet Functions | |||
Offset Formula | Excel Discussion (Misc queries) | |||
1 OFFSET FORMULA, I'M NOT SURE WHAT DOES IT MEAN!!!!!! | Excel Discussion (Misc queries) | |||
Offset in Formula | Excel Discussion (Misc queries) |