software

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 ----'


Craig Wrote:
gt; I am trying to create a formula in exel that will return a value from
gt; the
gt; final cell in a row. this cell reference will be moving on a weekly
gt; basis.
gt; example.
gt; Top row is filled in with a date field which is updated each week (this
gt; is
gt; the main reference point). Under this cell is number, but this could
gt; be
gt; blank. what i need to do is to only return the last value in that row
gt; in my
gt; reference cell.
gt; eg. cell a1 = needs data in from last cell in row only (n1)
gt; all cells from b1 to n1 will have numbers in them, but i only want to
gt; report
gt; the number in 'N1' cell. this cell reference will move each week to the
gt; right
gt; '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: www.excelforum.com/member.php...oamp;userid=30591
View this thread: www.excelforum.com/showthread...hreadid=502378Hi

Have a look at this thread:
groups.google.com/group/micro...96d223f78e1cde
It may help you.

Andy.

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

=LOOKUP(9.999E 307,B1:AZ1)

entered in cell A1. This will find the last value entered in the range
B1 to AZ1 - adjust to suit your situation. If you want to find the
(relative) position of this cell, use MATCH.

Hope this helps,

Pete