Hi All,
I have two challenges.
Challenge 1: to calculate the number of reps by their New/Old/Vacant status by month based on their call cycle
Challenge 2: to list the reps moving in, moving out and vacant by month based on their call cycle
I have attached the file with complete raw data as...
here is the raw data. There is differentiation on type of calls i am not looking for granular outcome. I am only interested in sequencing by order of first call to last call...
Thanks Chihiro,
I just found out what the issue is. I had to converted my raw data into a pivot first so that i have longitudinal view of calls by individual rep. The value filed (as shown in the snap shot attached) is as 'sum'. By default where ever there is blank, cell has 0 value (like you...
Hello everyone,
I have calls reported on different days of the month with gaps between two calls. I need to sequence the dates. For further clarification, i have attached the sample file with raw data and desired outcome tables. Anyone can help please....
Thanks,
Mitul
Hi everyone,
I am trying to count the number of cells between 1st data point to last data point. There are few blank months in between which also needs to be counted. I have attached dummy file for reference. Help please....
Thanks
Thanks a lot Chihiro, I used the option without helper and it worked perfectly. Since i had to avoid '0' and '#REF' error, I created a separate table using IF and IFERROR function.
This was very helpful....
Hi Chihiro,
Thanks a lot for quick reply.
Sorry i was not clear in my request to not to consider column C with month information for calculation. Is it possible to get the alignment without keeping column C info in the formula?
My actual data has spans over more than 2 years.
Other way is...
Hello everyone,
I have thousands of products launched at different time points. Want to align the sales from the month of their launch. Have attached file here as an example. Need a formula to this in Excel 2010
thanks