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:
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
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?