Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-15-2009, 09:22 AM
Nora Nora is offline could you help me help me with advanced filter Windows Vista could you help me help me with advanced filter Office 2003
Novice
could you help me help me with advanced filter
 
Join Date: May 2009
Posts: 1
Nora is on a distinguished road
Default could you help me help me with advanced filter


I have a problem with advanced filter (I know how to solve this question with autofilter)but i want it in advanced filter ..
..the question is( display the records of students whose total is greater than 90 %)

the report is attached
Attached Files
File Type: xls jjjjj.xls (14.0 KB, 16 views)
Reply With Quote
  #2  
Old 05-15-2009, 11:10 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline could you help me help me with advanced filter could you help me help me with advanced filter Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

If all you want to do is find records greater than 90% - there is no need to use Advanced Filter!

Advanced Filter is used when you want to filter by MORE than one criteria!

Using your Spreadsheet as an example:

If you wanted to know the names of students who achieved more than 5% in Quiz 1 AND more than 12% in the Practical, then you would use an Advanced Filter:

  • Copy row 2 (the headings) and paste below, or create two blank rows above your table and paste there (you MUST have at least one blank row below the pasted headings!).
  • In the blank row below the pasted heading, fill in the criteria for each column required (>5%, for column C), (>12%, for column J)
  • Open the Advanced Filter and choose to 'Sort in place'.
  • The List range is the full existing list (A4:M10)
  • The Criteria range is the pasted header and criteria row (A2:M3)
  • Click OK

The list will now only show 4 names - those are the students who scored more than 5% in Quiz 1 AND >12% in the Practical
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
junk email filter not working michmurp Outlook 0 09-15-2008 10:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:15 PM.


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