Search results

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

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

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

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

whenever i enter time into excel like 5:15 it automatically shows am or pm in formula bar which i dont want, i even formatted it like [hh]:mm but still it showing me am or pm in formula bar with time like 5:15 am so it should be seen like 5:15 in formula bar pls advice any formatting for this.

Hi Chandoo This is Shayeebur, I have made an Attendance sheet in which two same names are repeated but both are different people with different team names now look at excel, in first name Cindy Albert belongs to Team no. 401 & second Cindy Albert belongs to team no 406. Now i tried normal...

Hi I want to change name from Smith, John to John Smith & John Smith to Smith, John, how can I do via formula & not using text column feature pls advice I have attached the excel file. http://www12.zippyshare.com/v/36331786/file.html

Hi chandoo In column A1 to A3 I have entered the numbes as follows: 2.3 2.3 0.1 This means 2hours 30 minutes each & 10 minutes the 3rd one but when I sum them in A4 it calculates to 4.7 but I want to get result as 5hours 10 minutes. When I am trying to format the 2.3 to custom time format...

Hi This is shayeebur, u have posted one article upon vlookup the template file name was vlookup-on-multiple-conditions.xls in there u have taught me sales with below criteria that is salesman,region,month,product. The answer we can get by using 5 types of formulas that is sumifs...