Search EggHeadCafe's Job Board
EggHeadCafe Silverlight WPF ASP.NET VB.NET C# Excel SQL Server SharePoint
search
Office GroupsView
Excel
Excel Charting
Excel Crashesgpfs
Excel Misc
Excel Newusers
Excel Programming
Excel Setup
Excel Worksheet Functions
Word Application Errors
Word Conversions
Word Customization Menustoolbars
Word Docmanagement
Word Drawing Graphics
Word International Features
Word Mail
Word Mailmerge Fields
Word Newusers
Word Numbering
Word Oleinterop
Word Pagelayout
Word Printingfonts
Word Setup Networking
Word Spelling Grammar
Word Tables
Word Visual Basica Addins
Word Visual Basica Customization
Word Visual Basica General
Word Visual Basica Userforms
Works Win
Office Developer Automation
Office Developer Com Add_Ins
Office Developer Officedev Other
Office Developer Outlook Forms
Office Developer Outlook Visual Basica
Office Developer Visual Basica
Office Misc
Office Setup
Officeupdate
Onenote
Outlook
Outlook Bcm
Outlook Calendaring
Outlook Contacts
Outlook Fax
Outlook General
Outlook Installation
Outlook Interop
Outlook Mac
Outlook Printing
Outlook Program_Addins
Outlook Program_Forms
Outlook Program_Visual Basica
Outlook Teamfolders
Outlook Thirdpartyutil
Project
Project Developer
Project Server
Visio
Visio Developer
Visio General
Word Visual Basica Beginners
Outlookexpress General
Office Communicator
Word Programming
Office Templates Misc

Group SummariesView
.NET Framework
Access
BizTalk
Certifications
CRM
DDK
Exchange Server
FoxPro
French
French .NET
Games
German
German .NET
Graphic Design
IIS
Internet
ISA Server
Italian
Italian .NET
Maps
MCIS
Miscellaneous
Mobile Apps
Money
MSN
Networking
Office
Ops Mgr
Publisher
Security
SharePoint
Small Business
Spanish
Spanish .NET
SQL Server
Systems Management Server
Transaction Server
Virtual PC / Virtual Server
Visual Studio
Win32
Windows 2000
Windows 2003 Server
Windows 7
Windows Live
Windows Media
Windows Update
Windows Vista
Windows XP
 

View All Microsoft Excel Misc Posts  Ask A New Question 

Excel Spreadsheet

Que posted on Saturday, November 07, 2009 7:51 AM

I am an educator and I would like to develop a spreadsheet that calculates
the percentage of student grades. For example, The students took a test and I
would like to know that 80% of the class did 80% or better on any assessment.

Please assist...
reply

 

Say the data was

Gary''s Student posted on Saturday, November 07, 2009 8:50 AM

Say the data was like:

SMITH	51
JOHNSON	69
WILLIAMS	55
JONES	75
BROWN	65
DAVIS	83
MILLER	74
WILSON	81
MOORE	66
TAYLOR	83
ANDERSON	89
THOMAS	55
JACKSON	66
WHITE	74
HARRIS	84
MARTIN	79
THOMPSON	55
GARCIA	89
MARTINEZ	62
ROBINSON	67
CLARK	65
RODRIGUEZ	59
LEWIS	92
LEE	90
WALKER	73
HALL	90
ALLEN	95
YOUNG	59
HERNANDEZ	94
KING	89
WRIGHT	92
LOPEZ	94
HILL	72
SCOTT	57
GREEN	92
ADAMS	54
BAKER	73
GONZALEZ	74
NELSON	68
CARTER	83
MITCHELL	77
PEREZ	80
ROBERTS	90
TURNER	63
PHILLIPS	52
CAMPBELL	63
PARKER	63
EVANS	81
EDWARDS	62
COLLINS	93
STEWART	55
SANCHEZ	98
MORRIS	95
ROGERS	75
REED	57
COOK	62
MORGAN	66
BELL	62
MURPHY	83
BAILEY	71
RIVERA	61
COOPER	86
RICHARDSON	53
COX	76
HOWARD	97
WARD	76
TORRES	68
PETERSON	58
GRAY	56
RAMIREZ	72
JAMES	84
WATSON	52
BROOKS	82
KELLY	58
SANDERS	81
PRICE	100
BENNETT	78
WOOD	77
BARNES	98
ROSS	92
HENDERSON	91
COLEMAN	79
JENKINS	75
PERRY	63
POWELL	85
LONG	66
PATTERSON	74
HUGHES	93
FLORES	58
WASHINGTON	71
BUTLER	86
SIMMONS	94
FOSTER	78
GONZALES	69
BRYANT	67
ALEXANDER	66
RUSSELL	71
GRIFFIN	70
reply


Previous Microsoft Excel Misc conversation.