Hi
see:
http://www.xldynamic.com/source/xld.LastValue.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Beau Black" <Beau schrieb im
Newsbeitrag ...
I have an excel worksheet that keeps track of our gas inventory. We
get gas
delivered once a week and when its delivered we post the price. I
wind up
with a column that has prices and non entries. Month End i need the
LAST
price we were charged to produce a report. It would be nice if Visual
Basic
had a function called Last but alas I have not found it. I have to do
a lot
of gyrations to get this data. Does someone know an easy way to get
this data.