Hi, I am new on this forum. I am completely stuck with something that might seem easy at first sight.
We have clients, some are recurring clients, some aren't. We would like to do an analysis on how many projects we did with each client, how many month did it take each time, etc. Please see the screen shot below to see the kind of data we have and what we would like to get.
Formulae I tried:
- =ArrayFormula(index(B2:M2,match(2,1/(B2:M2<>"")))) to give me the last non blank cell. However, because I have several projects, it doesn't give me the end of the first project...
- =ArrayFormula(max(frequency(if(B2:M2<>0,column(B2:M2)),if(B2:M2="",column(B2:M2))))) but it gives me random numbers, I really don't understand the answers I get.
If you have any clue on how I can distinguish every project, I would be very grateful.
Thank you
We have clients, some are recurring clients, some aren't. We would like to do an analysis on how many projects we did with each client, how many month did it take each time, etc. Please see the screen shot below to see the kind of data we have and what we would like to get.
Formulae I tried:
- =ArrayFormula(index(B2:M2,match(2,1/(B2:M2<>"")))) to give me the last non blank cell. However, because I have several projects, it doesn't give me the end of the first project...
- =ArrayFormula(max(frequency(if(B2:M2<>0,column(B2:M2)),if(B2:M2="",column(B2:M2))))) but it gives me random numbers, I really don't understand the answers I get.
If you have any clue on how I can distinguish every project, I would be very grateful.
Thank you