Santhosh for 1st june she get comp off and your formula is correct, and 2nd june she had worked but half day that is also correct.
The problem is "Leave with loss of pay" for "Sachin G.A" he had no leaves and no production. so i need "LOP" for this perticular person. Regards Lokesh On Mon, Jun 18, 2012 at 1:39 PM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > Hi Lokesh, > > As per you mail and conditions I have applied and checked for the 1st 10 > rows (from akshata to kamalkar for 1st july) and they are working fine > marked in blue. > > If the amount is zero without any comments it is "L" row 2 for Anusha > > Please check and let me know. > > Regards > Santosh Kumar Subudhi > > ------------------------------ > Date: Mon, 18 Jun 2012 13:21:09 +0530 > > Subject: Re: $$Excel-Macros$$ Attendance tracker 2012 > From: lokeshsmg2...@gmail.com > To: excel-macros@googlegroups.com > > Hi Santhosh, > > Yes you are right, but when the amt is "0" with an comment "comp Off, > Halfday Leave, Loss of pay, Move to other project, Unplanned leave", that > time i need *this condition "See if the amt is "0" with comment It should > be "COMP","LOP","J","UL","M",* > > And *See if amt is "0" without any comment it should be "L". > > * > Please try once and do the needful santosh. > > Regards > Lokesh.M* > * > > > On Mon, Jun 18, 2012 at 1:15 PM, santosh subudhi < > santoshkumar.subu...@gmail.com> wrote: > > Hi Lokesh, > > As per you comments these are the below conditions that come up > > 1 If total amount colum is more than "0" it should be treated a "P" > 2 If total amount colum is "0" without any comment, it should be treated > as "L" > 3 If total amount colum is "0" with the comment Unplanned Leave , it > should be treated as "UL"" > 4 If total amount colum is "0" with the comment Comp Off, it should be > treated as "COM" > 5 If total amount colum is "0" with the comment Half Day Leave, it should > be treated as "HL" > 6 If total amount colum is "0" with the comment Loss of pay, it should be > treated as "LOP" > 7 If total amount colum is "0" with the comment Move to other project, it > should be treated as "M" > 8 If total amount colum is "0" with the comment Resignation, it should be > treated as "R" > 9 If total amount colum is "0" with the comment Joining, it should be > treated as "J" > > I have also created the tracker based on the above conditions which I have > already sent you in my previous mail. > > Regards > Santosh Kumar Subudhi > > > ------------------------------ > Date: Mon, 18 Jun 2012 11:51:05 +0530 > > Subject: Re: $$Excel-Macros$$ Attendance tracker 2012 > From: lokeshsmg2...@gmail.com > To: excel-macros@googlegroups.com > > Hi Santosh, > > > Thanks for resolving the query. See the below few conditions i needed. And > if you have any doubt send me an email. > > *See if amt is "0" without any comment it should be "L".* *See if the amt > is "0" with comment It should be "COMP","LOP","J","UL","M",* > based on comments i need the results in status colum. > > Regards > Lokesh.M > > On Sun, Jun 17, 2012 at 8:59 PM, santosh subudhi < > santoshkumar.subu...@gmail.com> wrote: > > Hi Lokesh, > > Hope you are fine!!! > > I have some confusion with the conditions that you stated > 1) As per condition one if the amount is more than zero it has to be > "P",however for Christina on 01-07-2012 you stated as half day same with > anusha with date 02-07-2012 > > 2) In conditions you mentioned as "loss of Pay",however in comments you > have used "leave with loss of pay". > > Still I have tried to solve you problems as per the conditions mentioned > on second sheet of the workbook. > > Comments: > 1)You have add a status colum as i have added on 01july and 02july for > every date and paste the formula on the 1st sheet. > 2)Secondly you need to enter the Vlookup formula for each date in second > sheet and just change the "coloum index number"accordingly. > 3)Name ranges have been used here( to view them CTRL+F3) > > -- > Regards > Santosh > santoshkumar.subu...@gmail.com > > > ------------------------------ > Date: Sun, 17 Jun 2012 18:39:19 +0530 > Subject: Re: $$Excel-Macros$$ Attendance tracker 2012 > From: lokeshsmg2...@gmail.com > To: excel-macros@googlegroups.com > > > Hi All, > > Please resolve this query whether using formula or an macro. I am waiting > for your reply do the needful. > > Regards > Lokesh.M > > On Sat, Jun 16, 2012 at 6:34 PM, Lokesh Loki <lokeshsmg2...@gmail.com> > wrote: > > Hi Experts, > > Till now i did not get any updates from the below request. Please do the > needful brothers. > > Regards > Lokesh.M > > > ---------- Forwarded message ---------- > From: *Lokesh Loki* <lokeshsmg2...@gmail.com> > Date: Fri, Jun 15, 2012 at 5:51 PM > Subject: $$Excel-Macros$$ Attendance tracker 2012 > To: excel-macros@googlegroups.com > > > Hi Experts, > > I need a help from you, i have attached excel file with the following > conditional formats and i need a below result on the *sheet 2* based on *date > wise* and total amount. > > Find the below results. and do the needful. > > Present P Planned Leave LUnplanned Leave ULComp OffCO Half Day LeaveHLMove > to Other Project > MResignation RJoiningJ Leave with loss of payLOP > Let me know if you have any clarification. > > Regards > Lokesh.M > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > -- > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, > accurate thread titles. Poor thread titles, like Please Help, Urgent, Need > Help, Formula Problem, Code Problem, and Need Advice will not get quick > attention or may not be answered. 2) Don't post a question in the thread of > another member. 3) Don't post questions regarding breaking or bypassing any > security measure. 4) Acknowledge the responses you receive, good or bad. 5) > Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. NOTE : Don't ever post personal or confidential > data in a workbook. Forum owners and members are not responsible for any > loss. > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com To > unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > -- > Regards > Santosh > santoshkumar.subu...@gmail.com > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > -- > Regards > Santosh > santoshkumar.subu...@gmail.com > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
