Hi all - quick brain bender for Monday!

I have a sheet that has weekly data in it. What I would like to do is
find a way to display the value of a cell that is 52 cells (weeks) to
the left of the furthest right cell with a value in it on a row. Or if
this can't be done, then just the value 52 cells to the left of a cell
in teh formula.

As ever, any help gratefully received.

Regards,

Chris


--
Tibbs
------------------------------------------------------------------------
Tibbs's Profile: http://www.excelforum.com/member.php...o&userid=15947
View this thread: http://www.excelforum.com/showthread...hreadid=561980