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: 2,292
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Any reason why the data should not be on one sheet in one table?
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
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: 2,292
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

I mean the data on existing sheets ( 1 and 2)
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
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 10:42 PM.


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