Looking at previous columns

[M3Cobb]

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?

[R.VENKATARAMAN]

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 <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Chris]

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