• 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.

Recent content by SG

  1. S

    Highlight duplicate & add data to another sheet

    Hi Experts, anyone working on this please.
  2. S

    Highlight duplicate & add data to another sheet

    Hi experts, Need your help again. I need to do some changes in my file. First, when the user enters the start & end time with same day with their name, it would become red highlighted & message popped out to change the time to void duplicate (row 10 & 13). Second, when they click the submit...
  3. S

    Select the month & display the weeks in charts - Please help

    Hi Narayan, Thanks for the solution. Can you please tell me more ways to represent such analysis.
  4. S

    Select the month & display the weeks in charts - Please help

    Hi Experts, I need your help in presenting the week wise time used in an account. What i need is to prepare a chart in which when i select month & name, the no. of weeks & its values in that particular month would be the source data of chart. For e.g, if i select 6 as month (which is june) &...
  5. S

    Sampling - Please check

    Hi Narayan, I have to display the samples in other sheet not in the raw data. Can you please modify the sheet as I have to select randomly 4 samples per person,per month with duration as per the slabs. The formula given by you selected the samples only on basis of duration. Can you please...
  6. S

    Sampling - Please check

    Thanks Narayan. I'll get back to you in case of any query.
  7. S

    Sampling - Please check

    Hi Narayan, Please find updated sheet for your reference. I have added the data. However, if for any person, calls can't sum up to 4, then it can select the sample less than 4 calls per month. Please help me with the maximum automation on this.
  8. S

    Sampling - Please check

    Hi Everyone, I need your help in choosing the samples for quality check. The only idea in my mind is the Random function but this wouldn’t suffice as there are 2-3 conditions on basis of which sampling should be done. It should be done for 4 calls per month,per person & per type (column A for...
  9. S

    Need Help in calculation of score

    Hi Experts, Need your help. What i need is to calculate the final score in column "I". All parameters have weightage except M(Fatal) parameter. I have tried the formula in Column I however, i'm, not able to do distribution of score in parameters.Please help me in calculating the score on basis...
  10. S

    need help in consolidating scores

    Is anyone working on it. It would be gr8 help.
  11. S

    need help in consolidating scores

    Experts, can anyone please look in to this & help me.
See more
Back
Top