match same number more than once

[racer3]

I would like to have cell E 2 show both the days from row A that corresponds to the max value (which is 90) in row B. My index and match formula only returns the first value from row A, telling me day 1, but the second 90 at day 4 does not.
from




A B C D E
------------------------------
day Max Min 1 4
1 90
2 80
3 70
4 90
5 60
6
7
8

[Sam Capricci]

this seems to work based on your limited data, CTRL+SHIFT+ENTER to activate it (it is an array formula).
{=IFERROR(INDEX(A:A,SMALL(IF($B$2:$B$9=90,ROW($B$2:$B$9)),ROWS($A$1:A1))),"")}

[racer3]

I am missing something. if I upload my file and explained would that be easier?

[FlameRetired]

Yes._________________

[Sam Capricci]

I'm attaching my interpretation of your post (if you want to upload one that is fine).

[racer3]

what I want to do is have cell E55 tell me the days of the max from B17 to B47. I have that figured out, but as you can see with more than one occurrence it will only
show the first one. I also want to do the same for the min but should be able to figure that out if I have the other. Thanks.

[Sam Capricci]

so where do you want the second (or third or more) value(s) put, which cell do you want day 4 to be in?
if you want it to be in cell E55 for the first and F55 for the second, then put this in E55 and drag right...
=IFERROR(INDEX($A:$A,SMALL(IF($B$17:$B$21=$C55,ROW($B$17:$B$21)),COLUMNS($A$1:A1))),"")
AGAIN, activated by CTRL+SHIFT+ENTER while still in the formula bar then when the {} appear on each end drag right.

[racer3]

Great! now how would I do the same for the MIN for E56 for the min values on C17 to C47?

[racer3]

Got it all figured out. Thanks so much for the help!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.