MIN If for Multiple Criteria

[eoinymc]

Hi,

Any chance anyone can help me here..I'm looking to find the minimum range based on two criteria.

1. It equals the city
2. It is greater than or equal to the time

So, here is a sample of what I have

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]LA[/TD]
[TD]17:45[/TD]
[/TR]
[TR]
[TD]LA[/TD]
[TD]06:30[/TD]
[/TR]
[TR]
[TD]NY[/TD]
[TD]15:00[/TD]
[/TR]
[TR]
[TD]NY[/TD]
[TD]18:00[/TD]
[/TR]
[TR]
[TD]LA[/TD]
[TD]18:00[/TD]
[/TR]
[TR]
[TD]LA[/TD]
[TD]20:00[/TD]
[/TR]
[TR]
[TD]NY[/TD]
[TD]19:45[/TD]
[/TR]
[TR]
[TD]NY[/TD]
[TD]08:00[/TD]
[/TR]
</tbody>[/TABLE]

So my two variables are:
1. LA
2. >= 17:30

Therefore, the result should return 17:45

Has anyone got any ideas how I can do this?

Cheers,

Eoin

 

[Andrew Poulsom]

That's:

=MIN(IF(A1:A8="LA",IF(B1:B8>=("17:30"+0),B1:B8)))

confirmed with Ctrl+Shift+Enter.

 

[eoinymc]

Thanks Andrew...works a charm!

Eoin