# Returning the last item in column

1. ## Returning the last item in column

I'm stumped by something that seems simple. I have a column of data that is
added to each day. I want to take the last value in this column each day and
enter in a daily summary row. My summary row contains sums and averages for
other columns, but I just need the last value in this particular column to be
transferred each day to the summary row. I can't find a formula or function
to accomplish this seemingly simple task. Any suggestions greatly appreciated.

2. ## Re: Returning the last item in column

HondaMike, Will return the last numeric valve in Column A

=LOOKUP(9.99999999999999E+307,A:A)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"HondaMike" <HondaMike@discussions.microsoft.com> wrote in message
news:A99A8560-2738-456C-8E43-9E331EAFB8E0@microsoft.com...
> I'm stumped by something that seems simple. I have a column of data that

is
> added to each day. I want to take the last value in this column each day

and
> enter in a daily summary row. My summary row contains sums and averages

for
> other columns, but I just need the last value in this particular column to

be
> transferred each day to the summary row. I can't find a formula or

function
> to accomplish this seemingly simple task. Any suggestions greatly

appreciated.

3. ## Re: Returning the last item in column

This might suffice for the purpose,
based on the conditions posted ..

Suppose the column is col A,
with data entered from row2 down successively
(without leaving any blank rows in-between)

Put in say, B1:

=INDEX(A2:A100,MATCH(TRUE,(A2:A100=""),0)-1)

Array-enter the formula,
i.e. press CTRL+SHIFT+ENTER
instead of just pressing ENTER

B1 will return the last value entered in col A

Adapt the range "A2:A100" to suit
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"HondaMike" <HondaMike@discussions.microsoft.com> wrote in message
news:A99A8560-2738-456C-8E43-9E331EAFB8E0@microsoft.com...
> I'm stumped by something that seems simple. I have a column of data that

is
> added to each day. I want to take the last value in this column each day

and
> enter in a daily summary row. My summary row contains sums and averages

for
> other columns, but I just need the last value in this particular column to

be
> transferred each day to the summary row. I can't find a formula or

function
> to accomplish this seemingly simple task. Any suggestions greatly

appreciated.

4. ## Re: Returning the last item in column

More formulae than you can imagine

http://www.xldynamic.com/source/xld.LastValue.html

--

HTH

RP
(remove nothere from the email address if mailing direct)

"HondaMike" <HondaMike@discussions.microsoft.com> wrote in message
news:A99A8560-2738-456C-8E43-9E331EAFB8E0@microsoft.com...
> I'm stumped by something that seems simple. I have a column of data that

is
> added to each day. I want to take the last value in this column each day

and
> enter in a daily summary row. My summary row contains sums and averages

for
> other columns, but I just need the last value in this particular column to

be
> transferred each day to the summary row. I can't find a formula or

function
> to accomplish this seemingly simple task. Any suggestions greatly

appreciated.

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1