# Frequency of consecutive negative numbers categorised by frequency

1. ## Frequency of consecutive negative numbers categorised by frequency

Hi,
I am trying to count the number of consecutive negative numbers in a list. I want to know the frequency of those negative numbers only apearing once, the same for those negatives appearing consecutively 2 times, for those 3 times....and so on.
eg.
-5624
-7455
-7846
-6742
-6868
8336
7238
-4544
-395
2425
5629
-6894
-8553
9720
12380
-18341
24394
-25962
24282
21322
-18343
18493
15352
For this I would get:
5 negatives consecutively = 1 time
2 negatives consecutively = 2 times
1 negative = 3 times
Thank you for your help.

2. ## Re: Frequency of consecutive negative numbers categorised by frequency

 Row\Col A B C D E F 1 Value Run Length Qty 2 -5624 0 5 D2: {=FREQUENCY(FREQUENCY(IF(A2:A23<0, ROW(A2:A23)), IF(A2:A23>=0, ROW(A2:A23))), C2:C7)} 3 -7455 1 3 4 -7846 2 2 5 -6742 3 0 6 -6868 4 0 7 8336 5 1 8 7238 0 9 -4544 10 -395 11 2425 12 5629 13 -6894 14 -8553 15 9720 16 12380 17 -18341 18 24394 19 -25962 20 24282 21 21322 22 -18343 23 18493

The formula says there are three runs of 1, 2 runs of 2, and 1 run of 5.

3. ## Re: Frequency of consecutive negative numbers categorised by frequency

Thanks a lot!

4. ## Re: Frequency of consecutive negative numbers categorised by frequency

You're welcome.

##### 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