2 thoughts on “Custom data validation in Excel in Hindi

  1. Kem

    Hello Sir
    I was watching your Excel tutorial videos on You Tube and I really appreciate your way of explanation which is so easy to understand. Sir I need some help on formula and that is for example I am working in an organisation where we work on shift basis with 3 teams involved that is you can say, A B and C and it is on target and performance, like I give an example let’s say in month of April Team A produced 10000 bags by using 600 staff and worked 22 days for that month and B Team produced 11000 bags they used 650 staff and worked 21 days whereas Team C produced 8900 bags using only 400 staff and worked for 23 days for that month. so as you can see here team A production was higher than Team B and C that is because Team A used more staff than Team B and C also you can see Team C production was very low and that is because Team C used Less staff than Team B and C . Now the problem comes when you get end of the month performance summary where you can see Team C performance is very low.so is there any formula you can use to justify production and get actual result. like
    10000 production staff used 600 days worked 22
    11000 production staff used 650 days worked 21 days
    8900 production staff used 400 and days worked 23. so is there any formula you can use production against staff and days worked to get exact answer. I will really appreciate if you can help me to solve this problem

    Best Regards



Leave a Reply

Your email address will not be published. Required fields are marked *