Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|