ExcelBanter - Help with a formula please?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Help with a formula please? (https://www.excelbanter.com/excel-discussion-misc-queries/199067-re-help-formula-please.html)

Victor Delta[_2_]

Help with a formula please?

"Jarek Kujawa" wrote in message
...
=MIN(IF(A1:A100="",ROW(A1:A100),""))

array-enter it = CTRL+SHIFT+ENTER

Many thanks,

V

Dave

Help with a formula please?

Hi,
or a non-array alternative:
=SUMPRODUCT(--(A1:A0100="")*ROW(A1:A100))-1
By the way, Jarek's formula also needs a minus one (-1) to give a correct
client count, since it counts the blank row, as mine does.
Regards - Dave.

"Victor Delta" wrote:

"Jarek Kujawa" wrote in message
...
=MIN(IF(A1:A100="",ROW(A1:A100),""))

array-enter it = CTRL+SHIFT+ENTER

Many thanks,

V

Victor Delta[_2_]

Help with a formula please?

"Dave" wrote in message
...
Hi,
or a non-array alternative:
=SUMPRODUCT(--(A1:A0100="")*ROW(A1:A100))-1
By the way, Jarek's formula also needs a minus one (-1) to give a correct
client count, since it counts the blank row, as mine does.
Regards - Dave.

Thanks. I'm actually using -2 to allow for the header row as well.

V

Dave

Help with a formula please?

Hi Victor,
My formula doesn't work at all! Don't know what I was thinking. Sorry.
It sums all the blank cells in the range, not just the first one.
Dave.

All times are GMT +1. The time now is 04:37 PM.