# Excel Function

1. ## Excel Function

how do I write a formula in Excel that returns the last value in a column of
figures? This column grow in length as numbers are added daily

2. ## Re: Excel Function

Try this:

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

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"DSS" <DSS@discussions.microsoft.com> wrote in message
news:E2EE77C5-9507-401F-9014-89FFD051C917@microsoft.com...
how do I write a formula in Excel that returns the last value in a column of
figures? This column grow in length as numbers are added daily

3. ## Re: Excel Function

try this:
=OFFSET(A1,count(A:A)-1,0)
You can change this formula until it returns the right result.

"RagDyer" wrote:

> Try this:
>
> =LOOKUP(9.99999999999999E+307,A:A)
> --
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "DSS" <DSS@discussions.microsoft.com> wrote in message
> news:E2EE77C5-9507-401F-9014-89FFD051C917@microsoft.com...
> how do I write a formula in Excel that returns the last value in a column of
> figures? This column grow in length as numbers are added daily
>
>

#### Thread Information

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