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