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
|