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
