#1
|
|||
|
|||
Attendance Analysis
Dear all
Is there any excel expert out there. I really need your expertise. I have an excel sheet which contain Student names, class, student attendance and their attendance percentage. I will need to further develop the worksheet into a new worksheet where by it will pull out the names and class of those students who had obtain less than 50% from sheet 1 and 2. Eg: Stephanie (From sheet 1), May and June (From Sheet 2) have attendance less than 50%. All 3 of them are from the same class. How do I pull of their names and put into a new sheet lets say sheet 3 Do get back to me regarding my queries. Your help is strongly appreciated. Thanks |
#2
|
||||
|
||||
Any reason why the data should not be on one sheet in one table?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Hi Pecoflyer
The reason is that we need only the names of students who obtain less than 50% attendance and their class |
#4
|
||||
|
||||
I mean the data on existing sheets ( 1 and 2)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
Hi Pecoflyer
The reason for having sheet 1 and sheet 2 is because they are students in different activities. Eg : Sheet 1 is football Sheet 2 is Dance |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Staff Attendance Calendar where text = values | sporter | Excel | 12 | 07-27-2016 07:55 AM |
office template: employee attendance tracker | LeylandRick | Excel | 2 | 01-08-2016 03:35 AM |
Export meeting attendance to .csv/Excel | danieljoachim | Outlook | 0 | 02-05-2015 06:44 AM |
Create an attendance sheet for monthly club meeting | jcc285 | Word VBA | 0 | 08-30-2014 09:34 AM |
Automate Office Attendance | kgwack | Outlook | 0 | 02-14-2012 09:39 AM |