Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 11-23-2016, 01:44 AM
LarryLee87 LarryLee87 is offline Windows XP Office 2013
Novice
 
Join Date: Nov 2016
Posts: 3
LarryLee87 is on a distinguished road
Default 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
Attached Files
File Type: xlsx Excel Sample.xlsx (14.3 KB, 2 views)
Reply With Quote
  #2  
Old 11-23-2016, 05:26 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 1,941
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
Default

Any reason why the data should not be on one sheet in one table?
Reply With Quote
  #3  
Old 11-23-2016, 08:50 AM
LarryLee87 LarryLee87 is offline Windows XP Office 2013
Novice
 
Join Date: Nov 2016
Posts: 3
LarryLee87 is on a distinguished road
Default

Hi Pecoflyer

The reason is that we need only the names of students who obtain less than 50% attendance and their class
Reply With Quote
  #4  
Old 11-23-2016, 10:47 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 1,941
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
Default

I mean the data on existing sheets ( 1 and 2)
Reply With Quote
  #5  
Old 11-23-2016, 05:14 PM
LarryLee87 LarryLee87 is offline Windows XP Office 2013
Novice
 
Join Date: Nov 2016
Posts: 3
LarryLee87 is on a distinguished road
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 11:49 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft