Forum Home
Press F1
 
Thread ID: 256 1998-10-09 11:18:00 reference last cell in an excel column Guest (0) Press F1
Post ID Timestamp Content User
556 1998-10-09 11:18:00 i wish to use this facility but can't seem to get it to operate.
can you please confirm the formula as listed or any other things i may be over looking.

many thanks
don dudley
Guest (0)
557 2005-01-28 09:02:00 not sure if you are still waiting found this

=LOOKUP(9.99999999999999E+307,worksheetname!column id:columnid)

e.g.

=LOOKUP(9.99999999999999E+307,Monthly!E:E)
petercon (135)
558 2005-01-28 09:08:00 Hi petercon :)

Not sure if you noticed the date on that post you replied to ... but it is over 6 years old now. Good of you to offer help, but it is safe to assume they have given up waiting for an answer.
Jen (38)
559 2005-01-28 09:53:00 it is safe to assume they have given up waiting for an answer.
Well you never know ;)

Actually, I might find that useful, even if don dudley doesn't :D

Mike.
Mike (15)
1