starmumbai
New Member
Dear All,
I would request your help in providing solution to the below problem.
Scenario:
I have approx 1500 employees in my organisation who need to compply for a block leave which should be continous 5 days.Employees apply through a leave system and I am able to pull a report of all the block leaves and sort it by employee id's.However there is no system hardstop preventing the employee from marking block leaves which are a) non continous & b) less than 5 days.
Scenario 1:Could you please assist in setting up some formula which will help me identify employees who have taken
a) non continous & b) less than 5 days.
Scenario 2:The final output should combine multiple rows of data into one row as shown in final output.
a)Calculate (add) the total number of leaves against each employee
b)Inputs the Earliest start date and latest end dates comparing multiple rows.
c)Highlight the non continous & less than 5 days and input comments as shown in sample.
Thankyou
I would request your help in providing solution to the below problem.
Scenario:
I have approx 1500 employees in my organisation who need to compply for a block leave which should be continous 5 days.Employees apply through a leave system and I am able to pull a report of all the block leaves and sort it by employee id's.However there is no system hardstop preventing the employee from marking block leaves which are a) non continous & b) less than 5 days.
Scenario 1:Could you please assist in setting up some formula which will help me identify employees who have taken
a) non continous & b) less than 5 days.
Scenario 2:The final output should combine multiple rows of data into one row as shown in final output.
a)Calculate (add) the total number of leaves against each employee
b)Inputs the Earliest start date and latest end dates comparing multiple rows.
c)Highlight the non continous & less than 5 days and input comments as shown in sample.
Thankyou