Excel Help

[Vince]

So I'm more excel savvy than your average Joe, but I know that's not saying too terribly much. My first question is specific, the second more general.

1) Is there a way to pull out the top x pieces of data from an array and sort them? I'm compiling lists of my students' times running a mile, and I want to motivate them by recognizing the top five or ten times.

2) Where's a good place online for Excel tutorials that aren't just for basic formulae?


Thanks in advance, guys.

[Vince]

Also, an addendum. Let's say I have the excel sheet set up like so --

Name -- Lap Time on Monday -- Lap Time on Tuesday -- etc

After finding the =min(Lap Time on Monday), is there any way to pull the corresponding name from column A out as well?

[wade moore]

You able to jump on AIM?

[Vince]

Heading on now. Fantasybandit, in case you didn't have it.

[gottimd]

So I'm more excel savvy than your average Joe, but I know that's not saying too terribly much. My first question is specific, the second more general.

1) Is there a way to pull out the top x pieces of data from an array and sort them? I'm compiling lists of my students' times running a mile, and I want to motivate them by recognizing the top five or ten times.

2) Where's a good place online for Excel tutorials that aren't just for basic formulae?


Thanks in advance, guys.

mrexcel.com forum is always a good place to go for help.

[FrogMan]

I'm sure wade will find a way to make it work for you but if not, pm me an email addy and I'll invite you to a google spreadsheet I just put together...

FM