I'd think that you should be concerned. If not:
=INDEX(TimeRange,MATCH(MAX(ResultRange),ResultRang e,0))
Jason wrote:
Aladin, is there a way to simplify the equation? I am not concerned about ties.
"Aladin Akyurek" wrote:
See my post in:
http://tinyurl.com/562xz
Jason wrote:
Time Result
0 0
5 300
10 52000
30 100
So that when the "result" is at a max, the coressponding time is retrived.
Thanks!
--
[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.