Looking at previous columns
 

I've got a pretty long multiple IF statement to work out the most recen
date from several columns, and then returns a figure in the column t
the left. This works fine, but I want to be able to use it to work ou
the previous figure. The previous figure will be 2 columns to the lef
of the most recent.

In short, All i want to know is...Is there a way of getting excel t
find the most recent figure and then jump back two columns

--
M3Cob
-----------------------------------------------------------------------
M3Cobb's Profile: http://www.excelforum.com/member.php...fo&userid=2498
View this thread: http://www.excelforum.com/showthread.php?threadid=38637

Looking at previous columns
 

hope I have understood. use offset function. offset(0,-2) will go to the
cell in the same row 2 columns to the left.


M3Cobb wrote in
message ...

I've got a pretty long multiple IF statement to work out the most recent
date from several columns, and then returns a figure in the column to
the left. This works fine, but I want to be able to use it to work out
the previous figure. The previous figure will be 2 columns to the left
of the most recent.

In short, All i want to know is...Is there a way of getting excel to
find the most recent figure and then jump back two columns?


--
M3Cobb
------------------------------------------------------------------------
M3Cobb's Profile:
http://www.excelforum.com/member.php...o&userid=24986
View this thread: http://www.excelforum.com/showthread...hreadid=386377

Looking at previous columns
 

M3Cobb

Don't know exactly what the code should be to jump a cell to te left,
but i know it can be done with 'cell offset'
Hope this will help you a bit.

Chris