Search results

Hi Luke M, Can you explain this formula and why are we multiplying it with one. Regards, Thakur

Hi Misra, Thankyou for your response. Had a question there are two words grapefruit and cinnmon when I put the formula in "Use a formula to determine which cells to format" under conditional formatting. It is not bolding the two words. Please advise.. Regards, Thakur

Hi, How to bold the text greater than 7 characters using conditional formatting. Please advise. Regards, Thakur

Hi, How to make every third row in this given list GREY using conditional formatting. Please advise. Thanks and Regards, K.K.Singh

Hi, How to calculate total score from the given table. Attaching the excel sheet. Please advise. Regards, Thakur

Hi, How to create an appropriate graph to represent Individual Names, their total scores based on their Groups. Attaching the spreadsheet. Please advise.. Thankyou Thakur

Hi, How to Create a Pivot using the below table to determine Each Individuals total score (all subjects) as per their GROUP. Please help..attaching the spreadsheet.. Thanks and Regards, Thakur

Hi, How do I apply conditional formatting using formula. Attaching the spreadsheet. Please advise. Regards, K.K.Singh

Hi, In the given expenses table data. How do I calculate expenses for all the months using excel formulae. Attaching the excel file with expenses table. Thanks and Regards, Thakur

Hi, Need help to calculate the stock prices of the companies based on their current and initial prices. a. In the Price Change column - calculate the exact price change of each company in $. b. In the Net Change column: Use an excel formula to determine if a company has seen an increase in...

Hi, Need help in writing excel macro which takes two different numbers from the user via a popup box and provides the sum of these two numbers in one cell.. Regards, Thakur

Hi Smallman, No, The criteria here I want is to capture employee taking Sick, PB unscheduled leaves before or after his weekly OFF. Basicly to track howmany such instances are there for all the employees. and if the Employee E1 is taking three days unscheduled leave for reasons like SICK it...

Hi, I am working on the leave data set..I need help tracking the unscheduled absenteeism in the data. How can I calculate the recurrence of unscheduled absenteeism keeping holidays in mind. https://www.dropbox.com/s/phqi712yhobber4/Unsched%20data.xlsx For eg: In the given data I need to...

Hi Chandoo, I am working on the leave data set..I need help tracking the unscheduled absenteeism in the data. How can I calculate the recurrence of unscheduled absenteeism keeping holidays in mind. https://www.dropbox.com/s/phqi712yhobber4/Unsched%20data.xlsx For eg: In the given data I...

Hi Chandoo, I have the data set which is used to track unscheduled leaves. https://www.dropbox.com/s/phqi712yhobber4/Unsched%20data.xlsx I wanted to track employees who are taking unscheduled leaves combined with their weekly offs. Like for eg: Emp 1 taking Sick leave and the next day...

Hi Narayan, I wanted to understand the linking of sheet 3 with the pie graph. Where you have created data labels and used formula's vlookup with the new data labels. I also wanted to understand Index and Match formula usage in the chart. Please advise.. Thanks and Regards, K.K.Singh

Hi Narayan, I wanted to understand the chart part, how did you create chart and linked it with the data to show the improvements in the parameters. can you help me understand the steps... Thanks Thakur

Hi Narayan, Thank you once again. But I wanted to understand the chart part, how did you create chart and linked it with the data to show the improvements in the parameters. can you help me understand the steps... Thanks Thakur

Hi Narayan/Chandoo.. When can I expect resolution to the data provided.. please let me know. Thanks and Regards, Thakur

Hi Narayan/Chandoo.. When can I expect resolution to the data provided.. please let me know. Thanks and Regards, Thakur

Hi Hui, The formula you suggested will give me count of how many candidates got all 4's or any number from the parameters. 1. What is the formula to know how each candidate has performed on each parameter. 2. How will I know on which parameter I need to improve on by seeing the data? 3...

Hi Hui, The formula you suggested will give me count of how many candidates got all 4's or any number from the parameters. 1. What is the formula to know how each candidate has performed on each parameter. 2. How will I know on which parameter I need to improve on by seeing the data? 3...

Hi Narayan, Please provide your expertise help on this report which I have sent 2 days before. Thakur

Hi Narayan, I am providing the link which has sample data https://www.dropbox.com/sh/tovdou4mt5hgrfe/KD878psFt2 The total score the candidate can score is 30 cutoff scr is 25 1. I wanted to create three buckets bucket 22, bucket >=24 and bucket 25 2. How do I create "Biggest...

Hi Hui, The formula you suggested will give me count of how many candidates got all 4's or any number from the parameters. 1. What is the formula to know how each candidate has performed on each parameter. 2. How will I know on which parameter I need to improve on by seeing the data...