Craig Wrote:
I am trying to create a formula in exel that will return a value from
the
final cell in a row. this cell reference will be moving on a weekly
basis.
example.
Top row is filled in with a date field which is updated each week (this
is
the main reference point). Under this cell is number, but this could
be
blank. what i need to do is to only return the last value in that row
in my
reference cell.
eg. cell a1 = needs data in from last cell in row only (n1)
all cells from b1 to n1 will have numbers in them, but i only want to
report
the number in 'N1' cell. this cell reference will move each week to the
right
'O1, P1 ----'

Hi Craig,
Read your query and trying to help...:) But not really understand
..
Can you elaborate more? Or you may want to attach a sample report..


--
Iris
------------------------------------------------------------------------
Iris's Profile: http://www.excelforum.com/member.php...o&userid=30591
View this thread: http://www.excelforum.com/showthread...hreadid=502378