Recent content by Shayeebur

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.