Finding Last Contiguous Column Cell Entry

Hi:
Sorry!! I lost the answered response to this problem (posted about a
week ago), so must re-post it again.
I have a column (A1:A100) that is only partially filled (A1:A21). I need a
function to find the last contiguous column entry. In other words, A1 thru
A21 has no blank entries. The answer, in this case would be a function to
find the contents of A21.

Thanks in Advance!!

--
Best Regards,
GBL Ô¿Ô

Is this what you are looking for?
http://www.google.co.uk/groups?hl=en...heet.functions

One way

=INDEX($A$1:$A$100,MATCH(TRUE,$A$1:$A$100="",0)-1)

entered with ctrl + shift & enter

what it does actually is to find the first blank cell and then goes one cell
above that (the - 1)

--

Regards,

Peo Sjoblom


"GBL" wrote in message
...
Hi:
Sorry!! I lost the answered response to this problem (posted about a
week ago), so must re-post it again.
I have a column (A1:A100) that is only partially filled (A1:A21). I need
a
function to find the last contiguous column entry. In other words, A1
thru
A21 has no blank entries. The answer, in this case would be a function to
find the contents of A21.

Thanks in Advance!!

--
Best Regards,
GBL Ô¿Ô

I don't think so since the OP wanted the last contiguous from start, those
formulas will return the last numeric value regardless of blanks.
--

Regards,

Peo Sjoblom


"MicrosoftUser" wrote in message
...
Is this what you are looking for?

http://www.google.co.uk/groups?hl=en...&rnum=1&prev=/
groups%3Fhl%3Den%26lr%3Dlang_en%26ie%3DUTF-8%26oe%3Dutf-8%26newwindow%3D1%26
safe%3Doff%26q%3DContiguous%2Bpooter%26btnG%3DGoog le%2BSearch%26meta%3Dgroup
%253Dmicrosoft.public.excel.worksheet.functions