Report Card help

[brianhum]

very basic question, need help

Im making a high school report card and need help on lowest, and highest mark

ie..

Course Mark

chem 90
phy 89
math 76
bio 64


i want to show the highest and lowest mark at the bottom of the card, so i use =b6, the lowest row ( i sort them highest to lowest)....but my question is howdo i do this if someone is taking more than 4 courses or less? then the results would be messed up a little. Thanks for your reply and time
This message was edited by brianhum on 2002-09-12 07:26

 

[lenze]

Use SMALL and LARGE (or MIN and MAX)

Book1
	A	B	C	D
1	COURSE	MARK		Highest Mark
2	Chem	90		90
3	Phy	89
4	Math	76		Lowest Mark
5	Bio	64		64
6	Eng	75
7	Music	80
...

This message was edited by lenze on 2002-09-12 07:40