• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. R

    Rep Movement Calcualtion

    @vletm Thank you for your help. Regards, Mitul
  2. R

    Rep Movement Calcualtion

    @vletm i don't have the formula set yet..... I am looking for results in the format same as dummy numbers in the updated version....
  3. R

    Rep Movement Calcualtion

    thanks veltm, You are right for challenge 1. here is the updated file with dummy results Regards, Mitul
  4. R

    Rep Movement Calcualtion

    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...
  5. R

    Call Dates Sequencing by serial number

    I used the Pivot option and it is working... Thank you very much... You are a savior...
  6. R

    Call Dates Sequencing by serial number

    Just a nadditional info - i have 7,600 reps and raw data has 70,000 entries
  7. R

    Call Dates Sequencing by serial number

    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...
  8. R

    Call Dates Sequencing by serial number

    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...
  9. R

    Call Dates Sequencing by serial number

    True, it works fine in the sample file. But not working in my master file. Thanks for the prompt reply....
  10. R

    Call Dates Sequencing by serial number

    Thank you Chihiro, somehow i am getting '1/0/1900' error with CSE. Not sure what would be the issue.
  11. R

    Call Dates Sequencing by serial number

    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
  12. R

    Count cells between first and last data input in a row

    Thank you Bosco... Much appreciated..
  13. R

    Count cells between first and last data input in a row

    Thank you Nebu... Much appreciated
  14. R

    Count cells between first and last data input in a row

    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
  15. R

    Align Sales by Launch Month

    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....
  16. R

    Align Sales by Launch Month

    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...
  17. R

    Align Sales by Launch Month

    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
Back
Top