Let A be the column of interest.On 2002-07-20 01:20, beachboy wrote:
First of all, thankyou to all, for your valuable replies and solutions to do things a number of different ways on my two previous posts.
I need to be able to find the cell reference nos of the first blank cell & last non blank cell in a particular column.
Is there a function to do this or ways to do this??
If A is of numeric type, use
If A is of type text, use
unless A contains * as value; Otherwise, use
unless the last cell might house a formula computed "".
 (or ) gives you the location/position of the last non-blank/used cell in A.
Let B1 house either  or .
will give you the value in the last used cell.
The location/position of the first blank/empty cell can be computed with:
which must be array-entered by hitting control+shift+enter at the same time, not just enter. B1, by the way, must house either  or .