View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
TUNGANA KURMA RAJU TUNGANA KURMA RAJU is offline
external usenet poster
 
Posts: 171
Default find date that meets a criteria

Mr.Biff,just for curiosity,how to get most volatile day and volatile spread
value from a specified date to end of range date(say today).

"Biff" wrote:

You're welcome. Thanks for the feedback!

Biff

"TUNGANA KURMA RAJU" wrote in
message ...
Thank you so much...its great.

"Biff" wrote:

Try this:

Array entered:

=INDEX(A2:A5,MATCH(MAX(B2:B5-C2:C5),B2:B5-C2:C5,0))

Format the cell as DATE.

Note: if there is more than one instance where the difference is the same
the first instance will be returned.

Biff

"TUNGANA KURMA RAJU" wrote
in
message ...
i need a function that gives me a date from
col A ---------------Col B-------------------Col C
Date----------------HighValue--------------LowValue
20/NOV/2006-----50.25--------------------48.50
21/NOV/2006-----60------------------------57.25
22/NOV/2006-----55.75--------------------50.25
24/NOV/2006-----52------------------------48
the difference of highvalue and lowvalue is the volatile spread value
of
the
day.
I want a function that gives me most(maximum) volatile day from the
above
range.
The answer of the above range is 22/NOV/2006.(spread values of above
range
are 1.75,2.75,5.50,4.00 and maximum value is 5.50).Thanks any body
gives
me a
compact function without creating a helper column to the above range.