Search results

Hello Mentors, I want to extract all the related information on the basis of UM name in this format. Can I get it out in the below format on Sheet 1? I have got output in sheet 2 by applying Vlookup but can I get output in that format? If yes then how? mentors, please help I have attached the...

thanks for the response. Is it not possible to show the start time and end time alone in stacked bar ?

Hello Mentors, I'm working on a project for work and I really need help on this part. I have a data set with two columns, the start time and end time of a machine. I want to show graph start time and end time process wise and gap in starting of one process to another Please guide me...

Dear Mentors , In my attached sheet I am trying to do ageing analysis. Please help me to get result under mentioned bucket in the sheet. also month wise aiming to get when was the incident open and close and average of incidents raised every month. please help me to get the result. Maddy

got it sir thanks.. what is the formula to get both the values into one table. Like in table two some of the customers not available which are in table 1. so instead of removing them how can I add those into new table with common list of customers in both the table.

Sir how can I get the list of customers with their count of req who were there in 2021. like eg Scottish Priosn was there in 2021 but not in 2022 , same for unity trust and D&G alson with those who are available in bth the list.

I accidently posted sir. no other intentions I had.

Hi sir, apologies, I got that. just wanted to be clear on reductions. Requests which are recvd in 2022 are for short tenure, how can it be justified against received in 2021.

Hello Sir, those were typing error. expecting cust name available in from both list and their count of req. Best, Madhoor

Dear Mentors, I am trying to get the reductions % of volume ( who all have stop sending req). Please suggest me how can I do that. In comparison tab I want) combined list of customer frm ( Some of them are common) both the tabs and count of req they have sent. How can I achieve it with the help...

I meant looking for help from 2 days but yet to find any.

Hi All, Pls see attached data file. In file I have rows which are Workout (total time ) -coretime ( Expected time on spend )- Productivity.. and Productivity at quartile 2 and quartile 3 + workout @quartile 2 and quartile 3. On the basis of data I want to do analysis of Tenure wise like...

can someone help me to find a solution. I want to show data in tenure wise like less than 6 months , <1 yr, >1&<2 and >2 yr . if workout at quartile 2 and quartile 3 is increasing does productivity at quartile 2 and 3 is also increasing? what is the variance between quartile 2 and 3 on workout...

Hi p45cal, i have attached sheet where on calculation part its mentioned how we got productivity at Quartile 2 and 3 and in same way workout at Quartile 2 and 3. I want to show tenure wise like less than 6 months , <1 yr, >1&<2 and >2 yr . if workout @ is increasing does productivity at 2 or 3...

Hi Peter, Based on this data I want to get maximum and minimum potential benefits from Productivity @ quartile 2 and quartile 3. Productivity baseline = sum of workout / sum of core time. Productivity at quartile 2 = total workout at Quartile 2 / core time and Productivity at quartile 3 = total...

Hi Peter, thank you so much for your response. can it be done by using any formula. Allow me sometime would share my requirement. Its Quartile data .srry for mentioning as Q(quarter). thanks Maddy.

yup.. Thanks Ali :)

can I get any suggestion?

Hi AliGW, Tenure Year Tenure Month 2 10 5 9 2 7 2 4 8 8 2 9 6 2 9 0 5 8

Hi All, Please advise how to converts 4 years + 10 months into total Months. Thanks Maddy

Hi All, Can somebody please help me to understand the data. I need to analyze the data in terms - what will be the gain in terms of productivity. what will be potential maximum and minimum benefits. Please help me to understand. I would really appreciate quick help on this. Thanks, Maddy

is it possible without VBA Ramesh?

Hi Team, Can someone please help me to find out formula to get the total count of cells in red. I have attached the sheet for reference.

Dear Bosco, thanks so much for helping me. just wanted to understand the process if you can as in how does it work. waiting for your reply Thanks