Ifs and buts...

Ifs and buts...

Post by Lee Gran » Tue, 16 Oct 2007 02:22:06

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

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?



Ifs and buts...

Post by Peo Sjoblo » Tue, 16 Oct 2007 02:57:05


look at the different players rankings, they are for points but would work
for times as well



Peo Sjoblom


Ifs and buts...

Post by Lee Gran » Tue, 16 Oct 2007 18:29:46

Thanks for that Peo - I'll look into it.