L
Lee Grant
Hi there,
I have a list of data (runners' race times actually) and I want to produce a
sheet shows certain combinations of data.
The data sheet has the runner data in rows with headers for the columns
(name, category, gender, finish time, etc.).
I've been using the =small function to find the quickest times (which is
fine) but how can I find, for example, the quickest male time?
Ideally I'd think I need some sort of combination of =SMALL with a AND (ie,
the lowest time with someone with a category of 'M' - but this doesn't seem
to be getting me very far.
Also I'd then like to go on and list things like - three quickest ladies,
all in the same team. This obviously would be some combination of the
finish time and the team column.
Can someone stop my head from hurting?
Any help is really appreciated,
Kindest Regards,
Lee
I have a list of data (runners' race times actually) and I want to produce a
sheet shows certain combinations of data.
The data sheet has the runner data in rows with headers for the columns
(name, category, gender, finish time, etc.).
I've been using the =small function to find the quickest times (which is
fine) but how can I find, for example, the quickest male time?
Ideally I'd think I need some sort of combination of =SMALL with a AND (ie,
the lowest time with someone with a category of 'M' - but this doesn't seem
to be getting me very far.
Also I'd then like to go on and list things like - three quickest ladies,
all in the same team. This obviously would be some combination of the
finish time and the team column.
Can someone stop my head from hurting?
Any help is really appreciated,
Kindest Regards,
Lee