Thread: How can I reference the last data item in a column or row?

I want to display or use the last (most recent) data in either a column

or row withour specifically accessing the individual cell. Is there a
funcion similar to Min() or Max() that can help me or perhaps another
way to solve this question?


Thanks

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

Hope this helps
Rowan

snappy wrote:
> I want to display or use the last (most recent) data in either a column
>
> or row withour specifically accessing the individual cell. Is there a
> funcion similar to Min() or Max() that can help me or perhaps another
> way to solve this question?
>
>
> Thanks
>

Hi!

Try this:

Note: this will not work on an entire column, i.e. A:A, but will work on an
entire row, i.e. 1:1

=LOOKUP(2,1/(A1:A20<>""),A1:A20)

Biff

"snappy" <plus1hdcp@hotmail.com> wrote in message
news:1131341198.945857.198210@g49g2000cwa.googlegroups.com...
>I want to display or use the last (most recent) data in either a column
>
> or row withour specifically accessing the individual cell. Is there a
> funcion similar to Min() or Max() that can help me or perhaps another
> way to solve this question?
>
>
> Thanks
>

Worked perfect and thanks for a great site to reference.

You're welcome.

snappy wrote:
> Worked perfect and thanks for a great site to reference.
>