1

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

1

Please Place under Highest

=ARRAY_CONSTRAIN(SORT(A2:B7,2,0),1,1)

and under Lowest

=ARRAY_CONSTRAIN(SORT(A2:B7,2,1),1,1)

Adjust ranges accordingly.

Get highest value of dates

Functions used:

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

Your Answer

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

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