Your terminology seems inconsistent with your sample file. You mentioned placing "X" if present and "A" if absent. But in your file, there are no "X's" or "A's". But P,L,U,E In which U and E represent Absent codes Unexcused and Excused But L in the legend says it represents Late yet in the summary, L represents "Leave"
The sample data ONLY uses P and L. In your Description, you say: "IF THE "A" BEYONDS <3+ Days Continuously " which reads if it's "A" LESS than 3 or more days... which doesn't make sense. 1 is less than three, and 30 is less than more than three. Do you really mean if it's "A" >3 days sequentially? Your example for "John" doesn't exist in the sample file. So I'm having trouble following it. For "John", the data for days 1-8 would read: P P P P L L L L Yet one of those days MUST be a Sunday. Which, according to your attached file, no attendance is recorded (or presumably required). Do you wish to exclude Sundays when counting sequential days? That is: Absenses on Friday, Saturday, Monday and Tuesday but being present before and after will count as 4 sequential absences? Also, the attendance January 2010 is complete (full month) Does 4 sequential absences anywhere in the month constitute "Irregular" or only the last 4 entries? And finally, before I move on... Do you care if it is a Macro/Function or do you require a Cell Function approach? I'd like to help, but it looks like I have to make WAY too many initial assumptions. Paul ________________________________ From: Joseph <rvijayanan...@gmail.com> To: excel-macros@googlegroups.com Cc: noorain.ans...@gmail.com Sent: Thu, January 6, 2011 1:52:56 AM Subject: $$Excel-Macros$$ breaking my head last six months-PLsssssss. Help Hi! I am Having one query i hope i can free at the end of the session. Please help me we are educational industry maintaining student attendance i am expecting report like this. now a days we are maintaining student attendance in excel 2007 when ever students comming in they are placed "X" mark end of the result cell will disply how many days "X" and how many day they are "A" now i am looking students those comming "X" >3 days Continuously result cell should disply "REGULAR STUDENT" IF THE "A" BEYONDS <3+ Days Continuously the result cell should disply "IRREGULAR STUDENT" for your clarification student John from 1st - 4 attended classes regulary the result cell should disply "Regular Student" from 5,6,7 he is on leave now it self the result cell should be in "Regular student" when he falls leave from 8th that is more than 3days the result cell should Automatically disply "irregular student" .I hope you got my point. so, Those who is on leave more than 3 days we have to follow the student status. for that i am breaking my head for last some months pls help me in this regard regards -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
