Get List Of All Values Corresponding To A Value In The Adjacent Column

[Admin]

Hi


In E1

=INDEX(B1:B7,SMALL(IF(A1:A7=C1,ROW(B1:B7)-ROW(E1)+1),D1))

It's an array formula. Where C1 is the dropdown value and E1 is the instance.

Please find attached.

[emmye998]

Great Master "Admin"
You are closer to the solution that I want
But you can change the number, in the column "d 1" automatically, with the change of condition
And why not bring, the rest of the values ​​in the column "A" with the other conditions change
Is it possible to change the values ​​in the column "E" without the column "d"
Thank you all

[Admin]

You got all the possible solutions. What you now want is not possible, though I could be wrong.

Best of luck.

[emmye998]

Yes, I think you're right
Thanks anyway, and unfortunately for your time
Thank you for Mister "Fox" Also, he is a man really nice