How to get row number of last non blank cell in range?

For example, I want to return last row number of non blank cells in a column, then return the value in cell. Example, I want to check last row number of range A11:A (from row 11 and below), then return last row number in cell A1 (same column), there are blank cells in A2:A10, but I only want to know the last row of non blank cell in column A.

I expect to return 16 to cell A1 for attached screenshot

I look for range A11:A , not sure how many cells below A11.
Or look into range A11:A1048576, then returns row number of last non empty cell.

EDIT - IGNORE @windknife provided a better solution


are you looking in range A11:A16 or A2:A16 - al little confused

anyway
=MATCH(2, 1/(A2:A100<>""))+1

the +1 is because it will provide a number based on the range
so as it starts at A2 - it will return 15 - so add1

same if you start the range at A11
=MATCH(2, 1/(A11:A18<>""))+10
you need to add 10

Originally Posted by etaf

are you looking in range A11:A16 or A2:A16 - al little confused

anyway
=MATCH(2, 1/(A2:A100<>""))+1

the +1 is because it will provide a number based on the range
so as it starts at A2 - it will return 15 - so add1

same if you start the range at A11
=MATCH(2, 1/(A11:A18<>""))+10
you need to add 10

I look into range A11:A , not sure how many cells below A11.
Or look into range A11:A1048576, then returns row number of last non empty cell. for screenshot, it should return 16

here's mine... =ADDRESS(MATCH(9.99999999999E+307,A:A),1,4,1)