I have a data set which has dates along the top. Clients down the side and revenue per day in the values field.
I need help to develop a formula and i think it will need to be an array formula which allows me to return the Value "Stopped" next to the activity (e.g. in A3 to say client 1 has Stopped) if the activity is no longer producing revenue per day. Rule would have to be if no revenue has been produced in last 2 days of data and not TODAY because data is not always up to TODAY date.
I also need another formula to return the date it stopped, so once i enter a client into N1, in O3 it produces the date stopped?
I need help to develop a formula and i think it will need to be an array formula which allows me to return the Value "Stopped" next to the activity (e.g. in A3 to say client 1 has Stopped) if the activity is no longer producing revenue per day. Rule would have to be if no revenue has been produced in last 2 days of data and not TODAY because data is not always up to TODAY date.
I also need another formula to return the date it stopped, so once i enter a client into N1, in O3 it produces the date stopped?