Search results

Hi Narayan Its working fine thanks a lot. You are truely genious.

Hi All This is Shayeebur . I had joined chandoo classes and Dashbaord 2 year back and even i enrolled power pivot classes from chandoo. Currently working as MIS executive in a bpo in Mumbai. This is a great place to learn excel. Chandoo and his Ninjas and his whole team doing brilliant job...

I think I am unable explain the question properly. Please find the attached exact file which I am finding out the skillset rank. Including Live & SDA only 6 employee can get upto 6 rank not like in live 6 people & SDA 6 people, it should be including Live & SDA only 1 to 6 rank will get. & rest...

Sorry Narayan i am trying to find out who is top 6 ranks if skill is Live and Training i mean including live & training 1 to 6 ranks and who is top 3 in Internet skill & who is top 3 rank in Super Calls skill & last one is top 3 rank Escalation Calls. Rest all will get “Rank 0” as their...

Thanks a lot Narayank. You are Genius. Thanks once again.

Hi All, I am facing difficulty in finding out Rank based on their Skill i.e. text against Points. I have name of the employees in Column C & their skill in Column D where they take calls and their achieved points column E. I need to get two Rank one is all Rank which is column F which I...

Thanks everyone who have replied out of their busy schedule. I will reply you all about it is working perfectly or not as currently i am unable to use excel. Thanks once again for your precious time.

Hi Chandoo, I am unable to get the correct answer from Rank formula as it skips the rank when the same value is repeated here I have attached the excel sheet. I am trying to get the rank on the basis of Points column as there are some points which are same because of that I am getting the same...

Thanks a lot Somendra have a nice evening.

Hi, Request you to please check and answer where I am making mistake as I am not getting the correct answer for the same. I tried but I am getting wrong answer using sumproduct. if there is other formula which I can use to get the answer then please let me know the same.

Hi Chandoo, I tried to get an answer but every time I need to do manual work. My Question is suppose my process head count is 105 employees & I have respective Team leaders for them you can have dump sheet on "Question" how I want my data is in sheet "My Answer", so to get data into my answer...

Hi Chandoo, There are columns with the name “Feedback Delivered Date” & my formula applies only on these columns & my formula is in column F that “First Feedback Date”. The formula is if column “Feedback Delivered Date” is contain NA then it jumps to the next “Feedback Delivered Date” & if date...

hi debraj Thanks a lot its working. Thanks once again

Hi Luke, Please have a look at this file

hi Luke, Sorry to say its not working. I have uploaded the file just have a look at this.

Hi chandoo, I have a worksheet in sheet1 in column A contains name and column E contains dates i am looking for macro if a person open this file the message pop up when column E date matches with todays date. The popup msg will be the persons name of the corresponding column e of todays date.

Thanx a lot Narayan its working, have a nice weekend.

Thanx a lot somendra its working

Hi There are lot of names are given with the specific colour i have to find out whether this colour matches with the statment could u just solve this question.

How to compute the total hours the person was available for 7 days .

How to calculate number of months without using helper column.

Hi hui, Thnks a lot Hats off to u

Hi If i entet 0 (zero) in any cell in this sheet it wont display 0 but if i enter anything other than zero value it can be seen. Can anyone explain what kind of formatting done to this workbook.

Hi Kindly answer me as i am unable to get the correct answer for this as i have attached the file.

hi i got the right answer for the above question but the thing is when the time is going more than 24 hours it is automatically converting to 1 hour like if the total sum of the time is 25 hours then it is showing as 1 hour. can anyone please tell me to get the answer as 25:00 instead of 1:00.