software

On one worksheet, I have several rows. Each time a new row of data is added,
I need to take the value from column B in the last row and display it in a
D3 on another worksheet. Can anyone help get me started?Ted

www.excelforum.com/showthread.php?t=519044
go here for an answer--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=519045No, I need the value from a column in whatever row is the most recent, the
last row which changes every so often. In other words, a row with new data
is entered every week, from this row, the last row with data in it....Ted

quot;davesexcelquot; gt; wrote
in message ...
gt;
gt; www.excelforum.com/showthread.php?t=519044
gt; go here for an answer
gt;
gt;
gt; --
gt; davesexcel
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=519045
gt;
Hi!

Is the data text, numeric or could it be either?

Biff

quot;Ted Dawsonquot; gt; wrote in message
...
gt; No, I need the value from a column in whatever row is the most recent, the
gt; last row which changes every so often. In other words, a row with new data
gt; is entered every week, from this row, the last row with data in it....
gt;
gt;
gt; Ted
gt;
gt;
gt;
gt;
gt; quot;davesexcelquot; gt;
gt; wrote in message
gt; ...
gt;gt;
gt;gt; www.excelforum.com/showthread.php?t=519044
gt;gt; go here for an answer
gt;gt;
gt;gt;
gt;gt; --
gt;gt; davesexcel
gt;gt; ------------------------------------------------------------------------
gt;gt; davesexcel's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=31708
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=519045
gt;gt;
gt;
gt;
The data will always be numeric.

Tedquot;Biffquot; gt; wrote in message
...
gt; Hi!
gt;
gt; Is the data text, numeric or could it be either?
gt;
gt; Biff
gt;
gt; quot;Ted Dawsonquot; gt; wrote in message
gt; ...
gt;gt; No, I need the value from a column in whatever row is the most recent,
gt;gt; the last row which changes every so often. In other words, a row with new
gt;gt; data is entered every week, from this row, the last row with data in
gt;gt; it....
gt;gt;
gt;gt;
gt;gt; Ted
gt;gt;
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;davesexcelquot; gt;
gt;gt; wrote in message
gt;gt; ...
gt;gt;gt;
gt;gt;gt; www.excelforum.com/showthread.php?t=519044
gt;gt;gt; go here for an answer
gt;gt;gt;
gt;gt;gt;
gt;gt;gt; --
gt;gt;gt; davesexcel
gt;gt;gt; ------------------------------------------------------------------------
gt;gt;gt; davesexcel's Profile:
gt;gt;gt; www.excelforum.com/member.php...oamp;userid=31708
gt;gt;gt; View this thread:
gt;gt;gt; www.excelforum.com/showthread...hreadid=519045
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;
Try this:

=LOOKUP(9.99999999999999E 307,Sheet1!B:B)

Change the sheet name as needed.

Biff

quot;Ted Dawsonquot; gt; wrote in message
...
gt; The data will always be numeric.
gt;
gt; Ted
gt;
gt;
gt; quot;Biffquot; gt; wrote in message
gt; ...
gt;gt; Hi!
gt;gt;
gt;gt; Is the data text, numeric or could it be either?
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Ted Dawsonquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; No, I need the value from a column in whatever row is the most recent,
gt;gt;gt; the last row which changes every so often. In other words, a row with
gt;gt;gt; new data is entered every week, from this row, the last row with data in
gt;gt;gt; it....
gt;gt;gt;
gt;gt;gt;
gt;gt;gt; Ted
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;gt; quot;davesexcelquot; gt;
gt;gt;gt; wrote in message
gt;gt;gt; ...
gt;gt;gt;gt;
gt;gt;gt;gt; www.excelforum.com/showthread.php?t=519044
gt;gt;gt;gt; go here for an answer
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt; --
gt;gt;gt;gt; davesexcel
gt;gt;gt;gt; ------------------------------------------------------------------------
gt;gt;gt;gt; davesexcel's Profile:
gt;gt;gt;gt; www.excelforum.com/member.php...oamp;userid=31708
gt;gt;gt;gt; View this thread:
gt;gt;gt;gt; www.excelforum.com/showthread...hreadid=519045
gt;gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;
OK, I get it now. Thank you.

Next question: Now I need to add together the last TWO cells in a particular
column... can we do that?Ted
quot;Biffquot; gt; wrote in message
...
gt; Try this:
gt;
gt; =LOOKUP(9.99999999999999E 307,Sheet1!B:B)
gt;
gt; Change the sheet name as needed.
gt;
gt; Biff
gt;
gt; quot;Ted Dawsonquot; gt; wrote in message
gt; ...
gt;gt; The data will always be numeric.
gt;gt;
gt;gt; Ted
gt;gt;
gt;gt;
gt;gt; quot;Biffquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; Hi!
gt;gt;gt;
gt;gt;gt; Is the data text, numeric or could it be either?
gt;gt;gt;
gt;gt;gt; Biff
gt;gt;gt;
gt;gt;gt; quot;Ted Dawsonquot; gt; wrote in message
gt;gt;gt; ...
gt;gt;gt;gt; No, I need the value from a column in whatever row is the most recent,
gt;gt;gt;gt; the last row which changes every so often. In other words, a row with
gt;gt;gt;gt; new data is entered every week, from this row, the last row with data
gt;gt;gt;gt; in it....
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt; Ted
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt; quot;davesexcelquot; gt;
gt;gt;gt;gt; wrote in message
gt;gt;gt;gt; ...
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; www.excelforum.com/showthread.php?t=519044
gt;gt;gt;gt;gt; go here for an answer
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; --
gt;gt;gt;gt;gt; davesexcel
gt;gt;gt;gt;gt; ------------------------------------------------------------------------
gt;gt;gt;gt;gt; davesexcel's Profile:
gt;gt;gt;gt;gt; www.excelforum.com/member.php...oamp;userid=31708
gt;gt;gt;gt;gt; View this thread:
gt;gt;gt;gt;gt; www.excelforum.com/showthread...hreadid=519045
gt;gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;
gt;add together the last TWO cells in a particular column

Will they always be contiguous?

Like this:

25
50

Or might there be blank cells in-between:

25

50

Biff

quot;Ted Dawsonquot; gt; wrote in message
...
gt; OK, I get it now. Thank you.
gt;
gt; Next question: Now I need to add together the last TWO cells in a
gt; particular column... can we do that?
gt;
gt;
gt; Ted
gt;
gt;
gt;
gt; quot;Biffquot; gt; wrote in message
gt; ...
gt;gt; Try this:
gt;gt;
gt;gt; =LOOKUP(9.99999999999999E 307,Sheet1!B:B)
gt;gt;
gt;gt; Change the sheet name as needed.
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Ted Dawsonquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; The data will always be numeric.
gt;gt;gt;
gt;gt;gt; Ted
gt;gt;gt;
gt;gt;gt;
gt;gt;gt; quot;Biffquot; gt; wrote in message
gt;gt;gt; ...
gt;gt;gt;gt; Hi!
gt;gt;gt;gt;
gt;gt;gt;gt; Is the data text, numeric or could it be either?
gt;gt;gt;gt;
gt;gt;gt;gt; Biff
gt;gt;gt;gt;
gt;gt;gt;gt; quot;Ted Dawsonquot; gt; wrote in message
gt;gt;gt;gt; ...
gt;gt;gt;gt;gt; No, I need the value from a column in whatever row is the most recent,
gt;gt;gt;gt;gt; the last row which changes every so often. In other words, a row with
gt;gt;gt;gt;gt; new data is entered every week, from this row, the last row with data
gt;gt;gt;gt;gt; in it....
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; Ted
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; quot;davesexcelquot; gt;
gt;gt;gt;gt;gt; wrote in message
gt;gt;gt;gt;gt; ...
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt; www.excelforum.com/showthread.php?t=519044
gt;gt;gt;gt;gt;gt; go here for an answer
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt; --
gt;gt;gt;gt;gt;gt; davesexcel
gt;gt;gt;gt;gt;gt; ------------------------------------------------------------------------
gt;gt;gt;gt;gt;gt; davesexcel's Profile:
gt;gt;gt;gt;gt;gt; www.excelforum.com/member.php...oamp;userid=31708
gt;gt;gt;gt;gt;gt; View this thread:
gt;gt;gt;gt;gt;gt; www.excelforum.com/showthread...hreadid=519045
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;
They should always be contiguous, but if you care to school all of us in
both scenarios...Ted
quot;Biffquot; gt; wrote in message
...
gt; gt;add together the last TWO cells in a particular column
gt;
gt; Will they always be contiguous?
gt;
gt; Like this:
gt;
gt; 25
gt; 50
gt;
gt; Or might there be blank cells in-between:
gt;
gt; 25
gt;
gt; 50
gt;
gt; Biff
gt;
gt; quot;Ted Dawsonquot; gt; wrote in message
gt; ...
gt;gt; OK, I get it now. Thank you.
gt;gt;
gt;gt; Next question: Now I need to add together the last TWO cells in a
gt;gt; particular column... can we do that?
gt;gt;
gt;gt;
gt;gt; Ted
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;Biffquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; Try this:
gt;gt;gt;
gt;gt;gt; =LOOKUP(9.99999999999999E 307,Sheet1!B:B)
gt;gt;gt;
gt;gt;gt; Change the sheet name as needed.
gt;gt;gt;
gt;gt;gt; Biff
gt;gt;gt;
gt;gt;gt; quot;Ted Dawsonquot; gt; wrote in message
gt;gt;gt; ...
gt;gt;gt;gt; The data will always be numeric.
gt;gt;gt;gt;
gt;gt;gt;gt; Ted
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt; quot;Biffquot; gt; wrote in message
gt;gt;gt;gt; ...
gt;gt;gt;gt;gt; Hi!
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; Is the data text, numeric or could it be either?
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; Biff
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; quot;Ted Dawsonquot; gt; wrote in message
gt;gt;gt;gt;gt; ...
gt;gt;gt;gt;gt;gt; No, I need the value from a column in whatever row is the most
gt;gt;gt;gt;gt;gt; recent, the last row which changes every so often. In other words, a
gt;gt;gt;gt;gt;gt; row with new data is entered every week, from this row, the last row
gt;gt;gt;gt;gt;gt; with data in it....
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt; Ted
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt; quot;davesexcelquot;
gt;gt;gt;gt;gt;gt; gt; wrote in
gt;gt;gt;gt;gt;gt; message
gt;gt;gt;gt;gt;gt; ...
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt; www.excelforum.com/showthread.php?t=519044
gt;gt;gt;gt;gt;gt;gt; go here for an answer
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt; --
gt;gt;gt;gt;gt;gt;gt; davesexcel
gt;gt;gt;gt;gt;gt;gt; ------------------------------------------------------------------------
gt;gt;gt;gt;gt;gt;gt; davesexcel's Profile:
gt;gt;gt;gt;gt;gt;gt; www.excelforum.com/member.php...oamp;userid=31708
gt;gt;gt;gt;gt;gt;gt; View this thread:
gt;gt;gt;gt;gt;gt;gt; www.excelforum.com/showthread...hreadid=519045
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;
If they're contiguous:

=SUM(OFFSET(B1,MAX(2,COUNT(B:B))-1,,-2))

If there might be blank or empty cells within the range: (it's a little more
complicated!):

Entered as an array using the key conbo of CTRL,SHIFT,ENTER:

=IF(COUNT(B1:B100)lt;1,0,SUM(B100:INDEX(B1:B100,LARG E(IF(B1:B100lt;gt;quot;quot;,ROW(B1:B100)),MIN(2,COUNT(B1:B100 ))))))

Biff

In this array formula you can't use entire columns as a range reference (in
certain expressions). I used a range of B1:B100. You don't need to know the
last entry is in B100 but just use a big enough range to cover the last
entry.
quot;Ted Dawsonquot; gt; wrote in message
...
gt; They should always be contiguous, but if you care to school all of us in
gt; both scenarios...
gt;
gt;
gt; Ted
gt;
gt;
gt;
gt; quot;Biffquot; gt; wrote in message
gt; ...
gt;gt; gt;add together the last TWO cells in a particular column
gt;gt;
gt;gt; Will they always be contiguous?
gt;gt;
gt;gt; Like this:
gt;gt;
gt;gt; 25
gt;gt; 50
gt;gt;
gt;gt; Or might there be blank cells in-between:
gt;gt;
gt;gt; 25
gt;gt;
gt;gt; 50
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Ted Dawsonquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; OK, I get it now. Thank you.
gt;gt;gt;
gt;gt;gt; Next question: Now I need to add together the last TWO cells in a
gt;gt;gt; particular column... can we do that?
gt;gt;gt;
gt;gt;gt;
gt;gt;gt; Ted
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;gt; quot;Biffquot; gt; wrote in message
gt;gt;gt; ...
gt;gt;gt;gt; Try this:
gt;gt;gt;gt;
gt;gt;gt;gt; =LOOKUP(9.99999999999999E 307,Sheet1!B:B)
gt;gt;gt;gt;
gt;gt;gt;gt; Change the sheet name as needed.
gt;gt;gt;gt;
gt;gt;gt;gt; Biff
gt;gt;gt;gt;
gt;gt;gt;gt; quot;Ted Dawsonquot; gt; wrote in message
gt;gt;gt;gt; ...
gt;gt;gt;gt;gt; The data will always be numeric.
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; Ted
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; quot;Biffquot; gt; wrote in message
gt;gt;gt;gt;gt; ...
gt;gt;gt;gt;gt;gt; Hi!
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt; Is the data text, numeric or could it be either?
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt; Biff
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt; quot;Ted Dawsonquot; gt; wrote in message
gt;gt;gt;gt;gt;gt; ...
gt;gt;gt;gt;gt;gt;gt; No, I need the value from a column in whatever row is the most
gt;gt;gt;gt;gt;gt;gt; recent, the last row which changes every so often. In other words, a
gt;gt;gt;gt;gt;gt;gt; row with new data is entered every week, from this row, the last row
gt;gt;gt;gt;gt;gt;gt; with data in it....
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt; Ted
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt; quot;davesexcelquot;
gt;gt;gt;gt;gt;gt;gt; gt; wrote in
gt;gt;gt;gt;gt;gt;gt; message
gt;gt;gt;gt;gt;gt;gt; ...
gt;gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;gt; www.excelforum.com/showthread.php?t=519044
gt;gt;gt;gt;gt;gt;gt;gt; go here for an answer
gt;gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;gt; --
gt;gt;gt;gt;gt;gt;gt;gt; davesexcel
gt;gt;gt;gt;gt;gt;gt;gt; ------------------------------------------------------------------------
gt;gt;gt;gt;gt;gt;gt;gt; davesexcel's Profile:
gt;gt;gt;gt;gt;gt;gt;gt; www.excelforum.com/member.php...oamp;userid=31708
gt;gt;gt;gt;gt;gt;gt;gt; View this thread:
gt;gt;gt;gt;gt;gt;gt;gt; www.excelforum.com/showthread...hreadid=519045
gt;gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;