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 PPlanned Leave LUnplanned LeaveULComp OffCOHalf Day LeaveHLMove to Other ProjectMResignationRJoiningJLeave 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
