"fzl2007" wrote:
=COUNT(B2:INDEX(B:B,MATCH(1E+300,B:B)))
- MATCH(2,1/(SIGN(INDEX(B:B,MATCH(1E+300,B:B)))
<SIGN(B2:INDEX(B:B,MATCH(1E+300,B:B)))))

Now. I have data on "Sheet1" and want results
on "Sheet2". How do I apply your formula so
that it will look up every other column starting
Column B on "Sheet1" and place the result on F6
"Sheet2", Column D on "Sheet1" and place result
on F7 "Sheet2"; Column F on "Sheet1" and place
result on F8 on "Sheet2" and on ... until
column is empty?

I hope someone else can step up and help you with that.

I can tell you that it is possible to do, and I could develop the formula.

But there are trade-offs to consider and some testing. I just don't have
that kind of time at the moment.

I will tell you that a solution based on repeated instances of my formula
above will become very time-consuming without boundaries.

So you might consider posting some reasonable boundaries. For example,
first and last possible row that might contain data, as well as last
possible column in Sheet1.

And you might consider whether a VBA macro solution would be acceptable.
Even if the VBA implementation might be slower, at least it would only run
when you decide to execute it. It could be implemented as "button" that you
can click after downloading new data.

One final caveat about my formula.... I just realized that I assume that
the numbers start in row 2 (of all columns). And they are contiguous
through the last row; no gaps in the data.

Are those assumptions acceptable?

Good luck with this.