Stumped on finding last row with data entered

I have a spreadsheet that I update each day. Every day I
create an entry on a row that has the date and in the
column beside it a dollar amount. Since I update this
list every day the list is getting quite long. I have
another cell at the top of my spreadsheet that I want to
put a formula in that displays the most recent dates
dollar amount. I can not figure out how to search the
column and display the most recent dollar value that I've
input. I assume there must be a function that will
search a column and report back the most recent additon
to the column or maybe something that will report the
last "non-empty" value in a column.

please help. I'm stumped

From Aladin Akyurek

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

or

=INDEX(A:A,MATCH(9.99999999999999E+307,A:A))

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Dig D" wrote in message
...
I have a spreadsheet that I update each day. Every day I
create an entry on a row that has the date and in the
column beside it a dollar amount. Since I update this
list every day the list is getting quite long. I have
another cell at the top of my spreadsheet that I want to
put a formula in that displays the most recent dates
dollar amount. I can not figure out how to search the
column and display the most recent dollar value that I've
input. I assume there must be a function that will
search a column and report back the most recent additon
to the column or maybe something that will report the
last "non-empty" value in a column.

please help. I'm stumped


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004

Thanks. The lookup function worked fine.


-----Original Message-----
From Aladin Akyurek

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

or

=INDEX(A:A,MATCH(9.99999999999999E+307,A:A))

--
Regards
Ken....................... Microsoft MVP -
Excel
Sys Spec - Win XP Pro / XL 00/02/03

---------------------------------------------------------
-------------------
It's easier to beg forgiveness than ask permission :-)
---------------------------------------------------------
-------------------



"Dig D" wrote in
message
...
I have a spreadsheet that I update each day. Every
day I
create an entry on a row that has the date and in the
column beside it a dollar amount. Since I update this
list every day the list is getting quite long. I have
another cell at the top of my spreadsheet that I want
to
put a formula in that displays the most recent dates
dollar amount. I can not figure out how to search the
column and display the most recent dollar value that
I've
input. I assume there must be a function that will
search a column and report back the most recent additon
to the column or maybe something that will report the
last "non-empty" value in a column.

please help. I'm stumped


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system
(http://www.grisoft.com).
Version: 6.0.558 / Virus Database: 350 - Release Date:
02/01/2004


.