Find last/previous non-blank cell in current column

From: NickDanger (NickDanger.16db5q_at_excelforum-nospam.com)
Date: 05/16/04 

Date: Sun, 16 May 2004 16:23:52 -0500

I would like to be able to grab a value from a cell in the current
column, starting at the current row, and looking backwards/upwards to
retrieve the last non-blank entry.

Can someone explain the formula or combination thereof that I could use
to make this happen? I'm not sure if this matters, but this column
contains date values.

Thanks! 

---
Message posted from http://www.ExcelForum.com/