Someone more knowledgable than me can probably cut this procedure down
but
I was able to get your 16-Nov like so:

With your first data row on row 4:
I created a "helper-column" (col D) - Cell D4 - =B4-C4 and copied down

Then in an out-of-the-way cell I entered (say J1):

=OFFSET(INDIRECT(ADDRESS(MATCH(MAX($D$4:$D$8),$D$4 :$D$8,0)+3,4)),0,-3)

The "+3" above allows for the 3 rows BEFORE the first data row;

Best I could do, for free...
HTH



"tkraju via OfficeKB.com" <u16627@uwe wrote in message
news:6978810c3b99e@uwe:

I have a range a1:c500.col A is "date",Col B is "high value",Col C is "Low
value".The basic calculation is "high value" minus "Low value" is volatile
value of the day.I need a function to find most volatile day from the above
range.
Col A(Date)-----------Col B(high value)-------------------Col C(Low value)
11-NOV -------------100 -------------------95
12-NOV --------------125 ---------------------115
13-NOV --------------122 ----------------------118
16-NOV --------------101 -----------------------90
18-NOV ---------------85 -----------------------84
From the above example the maximum difference value is 11(101-90),so the
most volatile day is 16-NOV.I tried with offset function ,could not succeed.
Please help.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200611/1