Return Text In Cell realting to Max Value in different colum

[samprince]

I am unsure how to write this formula.

In Column 0 - I have the Weekly Totals.
In COlumn F - I have the Week Beginning Date.



The max/min weekly totals change as time goes on.

How can I return the Date the Max/Min Occured in a separate sheet in the same workbook?

Tyvm

[starguy]

put a sample of your data.

[Dave Peterson]

=index(sheet1!f:f,match(min(sheet1!o:o),sheet1!o:o,0))
=index(sheet1!f:f,match(max(sheet1!o:o),sheet1!o:o,0))



samprince wrote:
>
> I am unsure how to write this formula.
>
> In Column 0 - I have the Weekly Totals.
> In COlumn F - I have the Week Beginning Date.
>
> The max/min weekly totals change as time goes on.
>
> How can I return the Date the Max/Min Occured in a separate sheet in
> the same workbook?
>
> Tyvm
>
> --
> samprince
> ------------------------------------------------------------------------
> samprince's Profile: http://www.excelforum.com/member.php...o&userid=34168
> View this thread: http://www.excelforum.com/showthread...hreadid=561972

--

Dave Peterson