=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