Excel Min Max Function 1

[t144]

I have figured out how to get a max from a column of numbers. The problem is that there is a date in another column associated with the max that I also need to display and I cannot figure out how to do this.

 

[bryanbayfield]

This sounds like a lookup problem. Do you want to return the date that matches to the maximum of your column of numbers? If so, and if your column of numbers appears to the left of your dates, try:

=VLOOKUP(MAX(range_of_numbers),table,col_index,FALSE)

table defines you range of numbers and dates
col_index defines the column within the table that contains your dates
FALSE means that you require an exact match which must be possible since your lookup value must be within the lookup range.

See Excel help for more info.