Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-23-2016, 01:44 AM
LarryLee87 LarryLee87 is offline Attendance Analysis Windows XP Attendance Analysis Office 2013
Novice
Attendance Analysis
 
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, 8 views)
Reply With Quote
  #2  
Old 11-23-2016, 05:26 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Attendance Analysis Windows 7 64bit Attendance Analysis Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 11-23-2016, 08:50 AM
LarryLee87 LarryLee87 is offline Attendance Analysis Windows XP Attendance Analysis Office 2013
Novice
Attendance Analysis
 
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 Attendance Analysis Windows 7 64bit Attendance Analysis Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #5  
Old 11-23-2016, 05:14 PM
LarryLee87 LarryLee87 is offline Attendance Analysis Windows XP Attendance Analysis Office 2013
Novice
Attendance Analysis
 
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
Attendance Analysis Staff Attendance Calendar where text = values sporter Excel 12 07-27-2016 07:55 AM
Attendance Analysis 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:46 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft