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
|