# (HELP) Counting Consecutive Values < 1 From Right

1. ## (HELP) Counting Consecutive Values < 1 From Right

Greetings !!
I need some help to count how many values that lower than 1 consecutively from right
Here the simple example

``Please Login or Register  to view this content.``
Thank you for helping

2. ## Re: (HELP) Counting Consecutive Values < 1 From Right

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

3. ## Re: (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

4. ## Re: (HELP) Counting Consecutive Values < 1 From Right

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.

5. ## Re: (HELP) Counting Consecutive Values < 1 From Right

My Mistake!

See DonkeyOte's solution in post #2

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

6. ## Re: (HELP) Counting Consecutive Values < 1 From Right

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

7. ## Re: (HELP) Counting Consecutive Values < 1 From Right

You're welcome. Thanks for the feedback!

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1