Search results

Working fine... Thanks to Narayan and SirJB7 Regards Raghunathan S

Hi, Thanks for your response. I tried the above formule in the sheet. It's working fine for the first row and from next row onwards the details column, it picks the data rather than nomenclature (viz. basic, hra, etc.) i'm not able to figure it out to correct the formulae. Pls. find...

Hi, I would like to extract data for me to integrate with the ERP System. Please find below the sample worksheet (link is mentioned below) https://dl.dropboxusercontent.com/u/67680061/Data%20Sheet.xlsx Data Sheet : Typical data we used in excell sheet. Data Extract : The data to be...

Thanks it is working fine...

Narayan, sorry to respond you late... Let me brief you... Point 1 : Salary Median at Grade / Level & Functional Level and would like compare an employees salary with the above median. If the current salary of an employee is less than the above median, i would like to correct. Point...

Srinidhi, Thanks for your quick response. To understand beter i mention the difference value in the colum D1. But i want the D1 column should be calculated automatically with the given set of rules. I tried your given formula.. But it is not the one i'm looking for. Thanks Raghunathan

Would like to compare the values of 2 different data (s) 3 variables are ; 1. Salary of an employee 2. Grade Salary median 3. Department salary median Based on the below crieteria, we would like to correct the employees salary. a) Wherever employee salary is lower than above...

Hi, I have few excel files which is used for calculation and data analysis. The data in each file has been consolidated to one file i.e. in the consolidated sheet, I have referred the data to other excel file(s). My question is :- If I move those worksheet (selective) to a file where the...

Thanks Hui, Really greatful to you with your quick response. Regards Raghunathan S

Dear all, At the outset, i woould like to thank all the forum members for their contribution to clarify so many excell queries. Really amazing ..!! With this in my mind, i thought you may help me to provide a solutions to my query. I have few sales guys who are eligible for incentives as...

Luke, Thanks for your support. But I have an error in few cases especially for whose joining dates in September 2010. It should be 12 months only. but the result was showing 18 months. One more issue which I forget to mention that the months should be rounded to nearest value 15 days...

I have the data (dd-mmm-yyyy) wherein i need to calculate no. of months served as upto 31st March 2012 from their joining date. a) If anybody serve less than a year then calculate actual months b) If any employee who is more than 18 months, the value restricted to 18 months. c) In all other...

Dear all, I need to present a chart tomorrow to my team about the performance of various business units with respect to Manpower utilisation, sales vs productivity, sqft utilisation with different business units, etc. The chart should be showing clearly on how they performed in last 1 year...

Hi, I work for a retail company based out of Bangalore. Thanks Raghunathan S

I would like to send a monthly dashboard on Human Resources & Administration. The dashboard will have information on ; (current month & YTD) 1. Head Count 2 monthly addition (No. of employees joined) 3. Attrition for the month & YTD 4. Exit Analysis (reason specific / period of service...

Anybody can share HR Dashboard. I have seen few dashboards here are more into Sales, Projects, etc. Thanks Raghunathan S

Hi, Greetings. Need a help to convert the currency (INR) to word (i.e. Rs.100/- to Rupees one hundred only). I beleive this would have asked by somebody else earlier in the forum. But i find it difficult to search that post. Can somebody help me to provide solutions. Thanks...

Dear Hui, Thanks. Its working fine now. I have one more query on this. Is there any way to add date suffix (viz. date followed by st for 1, nd for 2, rd for 3, th for 4 and so on) in the format ? Thanks btw Regards Raghunathan

Team, Need some clarifications on Date Format. I have the Date format in "dd-mmm-yyyy" and I would like to use certain datas for mail merge option. When I pull the above date format in the Word document, it shows me the numerical value of the date (i.e. some 33397, etc). I want the text in...