I have a sheet that looks like:

Date         Value      Highest     Lowest
1-1-2020     23         26           20 
2-1-2020     20
3-1-2020     26
4-1-2020     22
5-1-2020     24

Where highest is the highest value in the value row =MAX(B2:B999) and lowest is the lowest value in the value row =MIN(B2:B999) What I want is that below the highest value (26) I have the date of that value in this case 3 January. Also for the lowest I want to get the lowest date 2 January.

1 Answer 1


Please Place under Highest


and under Lowest


Adjust ranges accordingly.

Get highest value of dates

Functions used:

  • Thanks for taking the time to accept. Commented Apr 5, 2020 at 18:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.