Return Text In Cell realting to Max Value in different colum
 

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

Return Text In Cell realting to Max Value in different colum
 

put a sample of your data.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=561972

Return Text In Cell realting to Max Value in different colum
 

=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