Finding Last Contiguous Column Cell Entry

  • Thread starter Thread starter GBL
  • Start date Start date
G

GBL

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!!
 
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)
 
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 said:
Is this what you are looking for?
Click to expand...
http://www.google.co.uk/[email protected]&rnum=1&prev=/
groups%3Fhl%3Den%26lr%3Dlang_en%26ie%3DUTF-8%26oe%3Dutf-8%26newwindow%3D1%26
safe%3Doff%26q%3DContiguous%2Bpooter%26btnG%3DGoogle%2BSearch%26meta%3Dgroup
%253Dmicrosoft.public.excel.worksheet.functions
 
Back
Top