How to get lowest last date of lowest price if you have 2 or more equal lowest prices?

[Mathman]

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! ​

 

[Eric W]

Try:

	A	B	C	D	E	F
1
2	Dates	2018	2017	2016	2015	2014
3	Prices	5	5	5	7	10
4
5	Most recent date for low value
6	2018

<tbody>
</tbody>

Sheet8​

Array Formulas Cell Formula A6 {=MAX(IF(B3:F3=MIN(B3:F3),B2:F2))} <tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

You can also try:

=INDEX(B2:F2,MATCH(MIN(B3:F3),B3:F3,0))

if you don't want an array formula, and the dates are in descending order.

 

[Mathman]

Thanks!

 

[Eric W]

Glad to help!