Find smallest value in range and return adjacent values

**bunchie3174** · 06-23-2016, 06:23 PM

Hi all
I've created a league table for a mini TT championship at our cycling club. That all works fine but I'd like to extract the best placed riders for each age/ability group.
What formula would I need which will read the points column (AH) and find the lowest value that corresponds to the riders group (AI). Then next to the list of groups in column AP I want it to display the name associated with that time.
For example from the data below Michael B would appear in row 2 as fastest U10, and so on.
Hope that makes sense. I have been trying index, match, offset, small, vlookup and crying, I can't get it to work

POS No Overall Standings Pts Group Entrants

1 3 Michael B 73.25 U10 1 Youth E U8 2 Michael B
2 1 Ian B 73.60 E 2 Youth D U10 1 Ian B
3 2 Keith L 73.60 Elite 3 Youth C U12 1 Keith L
4 4 dave davey 79.00 U23 4 Youth B U14 1 dave davey
5 5 timmy d 83.00 Adult 5 Youth A U16 0 timmy d
6 7 jane doe 86.34 Cat 3 6 Junior U18 1 jane doe

**protonLeah** · 06-23-2016, 07:41 PM

title updated

**bunchie3174** · 06-24-2016, 04:26 AM

Bit harsh, I'm only looking for help.

**JohnTopley** · 06-24-2016, 04:30 AM

Can you please post a sample file showing some expected outcomes.

To upload a file: click "Go Advanced" then scroll down to "Manage Attachments"

**Tony Valko** · 06-24-2016, 05:13 AM

Originally Posted by bunchie3174

Bit harsh, I'm only looking for help.

Tip...

They don't do this at other Excel help forums!

**bunchie3174** · 06-24-2016, 06:09 AM

So basically in (AM) I want to display the riders from the league table (AD)based on the minimum time (AE) and group (AF).
I only need the fastest rider from each group to display in column AM.
The range AM5:AM28 will show the fastest in each group, that's the idea.