Help with a formula please?
 

On Fri, 15 Aug 2008 21:28:07 +0100, "Victor Delta" wrote:

I have a spreadsheet which contains rows of client data. The clients at the
top of the sheet are the active clients, and are separated from those at the
bottom (non active) by a blank row.

Can anyone help me with a formula which will give the number of active
clients i.e. by identifying the row of the topmost blank cell in column A.

Many thanks,

V

This **array-entered** formula will return a value indicating the first blank
cell in the range:

=MATCH(TRUE,ISBLANK(E:E),0)

You could subtract 1 (or 2 if you have a header row in the range) to get your
number of clients.

--ron

Help with a formula please?
 

"Ron Rosenfeld" wrote in message
...
On Fri, 15 Aug 2008 21:28:07 +0100, "Victor Delta"
wrote:

I have a spreadsheet which contains rows of client data. The clients at
the
top of the sheet are the active clients, and are separated from those at
the
bottom (non active) by a blank row.

Can anyone help me with a formula which will give the number of active
clients i.e. by identifying the row of the topmost blank cell in column A.

Many thanks,

V

This **array-entered** formula will return a value indicating the first
blank
cell in the range:

=MATCH(TRUE,ISBLANK(E:E),0)

You could subtract 1 (or 2 if you have a header row in the range) to get
your
number of clients.

--ron

Thanks,

V