I want to use Google Sheets to find the lowest price a stock has reached between two dates, or the lowest it has fallen in its life. I have tried various formulas but none have worked. Is there a way to do this?

Thanks, Nick

CodePudding user response：

i can't comment because of not enough reputation. you can try this below?

If you want to find the lowest price a stock has reached between two dates, you can use the following formula:

=MIN(B2:BJ2)

If you want to find the lowest price a stock has fallen in its life, you can use the following formula:

=MIN(B2:BJ2)*-1

The MIN function in Google Sheets can be used to find the minimum value between two dates.

CodePudding user response：

Use MINIFS function that will allow you to define the period.