Can somebody please help me with Excel? I have attached a spreadsheet called sample.xlsx. It is a huge spreadsheet with a bunch of dates in columns A and B, and a related numerical value for each date in column C. The actual spreadsheet is much larger but for brevity sake I have only filled in the month of August on the attached sample. Cells F3,F4, and F5 tell me the minimum, maximum, and average number in column c, based on the formulas:
F4 is =MIN(C:C), F5 is =MAX(C:C), and F5 is =AVERAGE(C:C)

• I am also able to display in which row of column C the maximum and minimum values are found using:
H3 is =MATCH(MIN(C:C),C:C,0) and H4 is =MATCH(MAX(C:C),C:C,0)
• What I wish to do also though, is display not only the row of column C where the minimum and maximum values are found, but also the actual associated date, I want these to display in cells J3 for the minimum and J4 for the date for the maximum value. In other words, I want cell J3 to display Aug 8 and I want cell J4 to display Aug 24. Any idea how I can do this? Many thanks.

Attached Files

SAMPLE.xlsx (10.2 KB, 8 views)