Conditional Count

[andrewc]

I am trying, without success, to create a formula that will refer to a column of data and do the following in one step:

1. Find the minimum value in the range, and then
2. From that minimum value, count back “up” the column the number of occurrences, including the minimum value, until a zero is reached. The zero should not be counted.

For example, if the values in A1:A6 are 1, 0, 2, -1, -2, 1, the minimum value is -2 and the count would return 3. (i.e. 2, -1 and -2)

Can someone please help?

Thank you!

[daddylonglegs]

Try this formula

=MATCH(MIN(A:A),A:A,0)-MATCH(0,A1:INDEX(A:A,MATCH(MIN(A:A),A:A,0)),0)

[andrewc]

Thanks very much