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

Some videos you may like

This Week's Hot Topics