Hi,
I am working on a data set, where each line represents an individual customer subscription ID. I have made a logic to determine if customer has an active subscription or not, but I would also like to identify recurring subscriptions. Example below - For customer "2136726" I would like to create a formula, if possible, to identify whether a customer has recurring activity after one or more periods of non-subscription. Basically identify first cell with data and then check if there are any blank cells before I get a new cell value in any later month (the actual number in each cell is irrelevant, as it only represents usage).
Appreciate any help
I am working on a data set, where each line represents an individual customer subscription ID. I have made a logic to determine if customer has an active subscription or not, but I would also like to identify recurring subscriptions. Example below - For customer "2136726" I would like to create a formula, if possible, to identify whether a customer has recurring activity after one or more periods of non-subscription. Basically identify first cell with data and then check if there are any blank cells before I get a new cell value in any later month (the actual number in each cell is irrelevant, as it only represents usage).
Appreciate any help
