The Punters Lounge - The World's Best Betting Forum - View Single Post

Jaded · 17-09-2006, 14:51

Probably a longshot, but is there any way in Excel of doing this?

Basically, I have a list of 25 pupils and their test marks. Is there a way of writing a formula so that a list appears of (say) the top 10 pupils?

17-09-2006, 14:51	#1 (permalink)
Jaded Kermit the Destroyer Join Date: 30 Jul 2005 Age: 27 Posts: 3,751	Lists in Excel Probably a longshot, but is there any way in Excel of doing this? Basically, I have a list of 25 pupils and their test marks. Is there a way of writing a formula so that a list appears of (say) the top 10 pupils?