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
