(HELP) Counting Consecutive Values < 1 From Right

Originally Posted by cplettner

Assuming first set of number is in A1 through A6

Copy the formula into the first cell of your answer column and drag down.

Please Login or Register  to view this content.

Cheers

thanks for the reply

but it count all the values that lower than 1
whereas i need to count only the consecutive values from the right
i already mentioned it on the example

Originally Posted by Tony Valko

Try this...

Data Range

	A	B	C	D	E	F	G
1	------	------	------	------	------	------	------
2	10	1	0.1	0	0		3
3	10	1	0.1	0.9	0		3
4	0.2	0.1	1	0	0		2
5	10	1	0.1	0	1		0
6

This array formula** entered in G2:

=COLUMNS(A2:E2)-MATCH(2,1/(A2:E2>=1))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy down as needed.

thanks tony
it works perfectly !!

Originally Posted by cplettner

My Mistake!

See DonkeyOte's solution in post #2

http://www.excelforum.com/excel-gene...-than-0-a.html

thanks for your help