Lowest 3 number
Posted by Jim on February 27, 2001 4:41 PM
Hi,
Don't mean to insult anyone's intelligence, but how do I throw out the lowest three homework scores if I'm using excel as a gradebook? Thanks!
Posted by David Hawley on February 27, 2001 5:35 PM
Hi Jim
You could use the:
=SMALL(A1:A12,1)
=SMALL(A1:A12,2)
=SMALL(A1:A12,3)
Where A1:A12 contain you scores and 1,2 and 3 are the K-th smallest values.
Dave
OzGrid Business Applications
Posted by Jim on February 28, 2001 7:37 AM
Thanks, Dave.
