Thread: formula and offset
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JMB JMB is offline
external usenet poster
  
Posts: 2,062
Default 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 With QuoteReply With Quote