If you can help that would be great.
Here's the example
Dates in years 2018 2017 2016 2015 2014
Prices 5 5 5 7 10
First the lowest price is 5 but then based on that I want the most recent or closest date to current which in this case would be year 2018.
Any suggestions?
Thank you!
Here's the example
Dates in years 2018 2017 2016 2015 2014
Prices 5 5 5 7 10
First the lowest price is 5 but then based on that I want the most recent or closest date to current which in this case would be year 2018.
Any suggestions?
Thank you!