Thanks for your effort in this Biff.

I had a suspicion that perhaps that Index formula might be the fastest, but
I can see I was way off.

Good old Sumproduct appears to be a steady, all-around, workhorse choice.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"T. Valko" wrote in message
...
http://img158.imageshack.us/img158/5...lctimesme8.jpg

Times based on Charles Williams RangeTimer method:

http://msdn2.microsoft.com/en-us/library/aa730921.aspx

--
Biff
Microsoft Excel MVP


"Ragdyer" wrote in message
...
Just as a point of information, can anyone out there with access to Fast
Excel or other similar software determine which of these formulas would
be
faster and less resource intensive?

Say you size them to 7,000 rows.

Gary's Sumproduct:
=SUMPRODUCT(MAX((A1:A7000="north")*(B1:B7000="high ")*C1:C7000))

Tm's Index:
=MAX(INDEX((A1:A7000="north")*(B1:B7000="high")*C1 :C7000,0))

OR, a standard *array* entered formula:
=MAX((A1:A7000="north")*(B1:B7000="high")*C1:C7000 )


--
Regards,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-

"mwd" wrote in message
...
Hi

I have a spreadsheet that contains text and time information such as
below:
a b c
1 north high 5:21
2 south low 6:42
3 north low 7:14
4 north high 3:56
5 east low 2:14
6 north low 2:02
7 north high 2:37
All of the information in the spreadsheet is the result of formulas
from
other data (in other sheets).
I need a formula that will provide the maximum time (in Col C) in a row
where (for example) the Col A is "north" and Col B is "high".
Any help would be greatly appreciated.
Thanks.