consecutive values

  1. M

    Counting the frequency of consecutive values in a column with multiple conditions

    I am looking for assistance with counting the frequency that TIMEOUT appears consecutively for each driver on each day. I'm looking for instances TIMEOUT appears 3 times consecutively for a driver on a given day. At that point I'd like to know the number of rows that appear after the 3rd...
  2. J

    Consecutive Numbers VBA Help

    Hi All, I am in need of some help! On one sheet I have a list of numbers listed in consecutive order e.g. 1 2 3 4 5 6 On the second page I have a similar list of consecutive numbers but I need my macro to update the second sheet with the additional consecutive numbers that ar eon shete one...
  3. M

    Counting Number of Consecutive Occurrences of Specific Value

    Okay so I think I've exhausted my googling/foruming options trying to figure this out. I've found a ton of things that are very close to this problem but not quite the same. I'm pretty certain I'm going to need an array formula. Essentially I have data that looks like this: <tbody> Date Numb...
  4. K

    Counting consecutive values

    I am trying to figure out a way to count the days worked in between days off in a 2 week period. I have a column for each of the days of the week, in those columns reflect the start time if they are working or Off if they are off for that day. The formula I tried in column S is...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top