consecutive occurrences

  1. J

    Need Help?? (Not sure what function to use)

    Hi, I am trying to write a formula that will tell me if a client is new or existing. Below is some sample data of the file I am working with. <colgroup><col><col><col span="25"></colgroup><tbody> Client New/Existing Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17...
  2. A

    Count occurrences of consecutive text

    Hi, Is there a formula to count occurrences of consecutive text in a lengthy file, and put the number in an adjacent column, as in the sample below: <colgroup><col><col></colgroup><tbody> 019DAEA5-7213-4CA8-A421-C8E6696CFE10 3 019DAEA5-7213-4CA8-A421-C8E6696CFE10 3...
  3. K

    How to concatenate separate fields based on consecutive equivalent values

    I have 2 columns, 200k rows: <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono"...
  4. T

    Running Tally of Consecutive Yeses and Nos. (Where minus 3, plus 1 = +1)

    I am trying to build a formula that will register the number of consecutive days a given task is either completed or not completed. The most recent cell (C1) should show a positive or negative value. A positive value will be the number of consecutive days the task wasc ompleted. A negative...

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