Troubles with the OFFSET function

For the last numerical value...

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

For the minimum value for the last 60 entries, provided there are no
blanks within your range...

=MIN(OFFSET(Sheet1!B1,MAX(0,COUNTA(Sheet1!B:B))-60,0,60,1))

For the maximum and average, replace MIN() accordingly.

Hope this helps!

In article <01E84F3C-EDB2-43FC-BEE5-B1AB7B5C0BBB@microsoft.com>,
"ghostrider" <ghostrider@discussions.microsoft.com> wrote:

> Hey all. Here is my dilemma. On sheet 1 column B i currently have 64
> numerical entries to which i am adding 1 entry each day. On sheet 2 i am
> trying to do the following things. First i want one cell to automatically
> display the last entry i have made. Secondly, i am trying to do min max and
> averages for the last 60 entries.
>
> I know that you need to use some combination of the count function within
> the offset function but cant seem to get it right. I am uncertain of what i
> should be using for the reference, rows, columns, height width parts. Any
> suggestions???
>
> Thanks much.

Correction...

=MIN(OFFSET(Sheet1!B1,MAX(0,COUNTA(Sheet1!B:B)-60),0,60,1))

In article <domenic22-D9B9D0.08515701062005@msnews.microsoft.com>,
Domenic <domenic22@sympatico.ca> wrote:

> For the last numerical value...
>
> =LOOKUP(9.99999999999999E+307,Sheet1!B:B)
>
> For the minimum value for the last 60 entries, provided there are no
> blanks within your range...
>
> =MIN(OFFSET(Sheet1!B1,MAX(0,COUNTA(Sheet1!B:B))-60,0,60,1))
>
> For the maximum and average, replace MIN() accordingly.
>
> Hope this helps!