Return Text In Cell realting to Max Value in different colum

S

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 i
the same workbook?

Tyv
 
D

Dave Peterson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Max; Min & Dates 2
max and min help. 5
Return cell reference rather than value 4
how do I return tthe location (cell) when using the max function 6
MAX AVERAGE MIN with additional criteria, ignoring blank cells 6
Automatically highlight max and min values in a column in Excel 2
Excel Timesheet Error 2
MAX across worksheet, return text value 8

Top