misrasomendra
Board Regular
- Joined
- Nov 17, 2012
- Messages
- 74
Hi all excel experts,
Here I have a problem with counting number of leaves. Suppose below is my data
If you see I am counting total leaves for each employee. But here is one condition if between two leaves any sunday or any holiday will come that should also be counted as leaves.Like Name 2 there is one Holiday (H) and one Sunday(S) followed by and precedded by L. So they should also get counted as Leaves. There can be situations like PPLLLHHHLLLPP or PPPPLLSLPPH.
<TBODY>
</TBODY>
Any help regarding what formula should deliver me the result. I think frequecy can do it but I am unable to figure out how?
Thanks in advance.
Regards!
SM.
Here I have a problem with counting number of leaves. Suppose below is my data
If you see I am counting total leaves for each employee. But here is one condition if between two leaves any sunday or any holiday will come that should also be counted as leaves.Like Name 2 there is one Holiday (H) and one Sunday(S) followed by and precedded by L. So they should also get counted as Leaves. There can be situations like PPLLLHHHLLLPP or PPPPLLSLPPH.
Emp Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | TOTAL LEAVE |
Name 1 | P | P | L | L | H | S | P | L | 3 |
Name 2 | P | L | L | L | H | S | L | P | 6 |
Name 3 | P | P | P | P | H | S | P | P | 0 |
<TBODY>
</TBODY>
Any help regarding what formula should deliver me the result. I think frequecy can do it but I am unable to figure out how?
Thanks in advance.
Regards!
SM.