Hi there,

I'm trying to analyse an excel sheet and it's not going well!!!

Our running club has just hosted a race and I'm trying to do some analysis
on the entrants and create a report sheet..  Here is a rough outline of the
sheet.

Column C - Bib Number
Column D - First Name
Column E - Surname
Column J - Club
Column M - Category
Column N - Gender
Column Q - Finish

Other columns have data that is either not used or is empty.

To start with I wanted to find the top 3 finishers in the race.  On a
seperate sheet I have put the following formula into a cell:

=SMALL('CC Import'!$Q$2:$Q$252,1)

Obviously this finds the lowest time in my Q column (finish times)

To find some more details about that runner I used the following formula:

=OFFSET('CC Import'!$A$1,MATCH($E5,'CC Import'!$Q$2:$Q$252, 0),12)

By switching the '12' at the end I can quite hapilly trawl up and down
columns getting data I want.  So far so good.  Here is the bit I'm having
trouble with.

I now want to find the quickest runner (using the times in Column Q) that
are also in have a value in the Category column (M) of 'F'.

From there I think i need to use a varient of the offset formula to pull
back data from along the same row.

I just cannot get my head around this but I think I may be close!!!

Can anyone shove me in the correct direction?

Cheers

Lee