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

http://www.yqcomputer.com/

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

for times as well

--

Regards,

Peo Sjoblom

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

for times as well

--

Regards,

Peo Sjoblom

1. ifs and buts

4. IF's & AND's

5. multiple ifs & ands indirect/offset...need help desperately pl

6. multiple ifs ands & indirect or offset?

7. Nesting IF's and AND's - a bit of help please...

8. two questions: and's inside if's and checking the return code of a program

9. Multiple Nested IFs, ORs, Ands

10. Multiple ifs, and ands, and are not working

11. multiple ifs & ands indirect/offset...need help desperately please

12. Ifs and Ands - I'm confused!

13. "ifs", "ands" & "vlookups"

14. New IFS interface (jfs.ifs, udf.ifs for example)

15. Small (JFS.IFS or HPFS.IFS AutoCheck) install bump, Solved!

3 post • Page:**1** of **1**