Hi,

I have a spreadsheet with dates and amounts in columns A and B.  I want to
retrieve the last date and amount in both columns right before the empty
cells.  The dates are in ascending order and there are spaces in some rows
and some of the amounts can be spaces or zero.

Here is an example

Column A   Column B
....other data here
...spaces here
01/01/2001    0
01/02/2001    5000
01/01/2002    10000
01/01/2003    20000
01/01/2004    25000
01/01/2005    0
...spaces here
10/27/2006    30000
10/28/2006    35000
...empty cells here

I want to retrieve the the last row which contains the date of 10/28/2006
and the amount of 35000 into two cells adjacent to each other just like they
are stored in column A and B of the table above.

Any help greatly appreciated.