formula to show first and last row results based on creteria

Hi,

I am pretty sure there is a way but I have been struggling with this tonight. Is there a formula that can show the first value/text that appears in a row based on a criteria and a separate formula that shows the last value/text in a row based on the same criteria?

As an example if column A had "Apples" from A1:A5 and column B1:B5 had the color type of the Apples, I was hoping the formula can display the first color in B1 and the last color in B5.

Thanks.
Pi*

to know the first color (array formula)
=INDEX($B$1:$B$5,MIN(IF($A$1:$A$5="aple",ROW($A$1:$A$5))))

to know the last color (array formula)
=INDEX($B$1:$B$5,MAX(IF($A$1:$A$5="aple",ROW($A$1:$A$5))))

I appreciate the feedback. I have attached a sample file showing the results I am anticipating...

Thank you Ghozi Alkatiri for the assistance but it seems the formula shows the same results instead of the first and last value of the criteria. I uploaded a sample file

These worke fine for me (asper original formulae)

=INDEX($B$1:$B$18,MIN(IF($A$1:$A$18=E2,ROW($A$1:$A$18))))

=INDEX($B$1:$B$18,MAX(IF($A$1:$A$18=E2,ROW($A$1:$A$18))))

BOTH ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

THEN copy/Paste in pairs

at F2 try this formula (formula array)
=INDEX($B$2:$B$18,IF(COUNTIF(E$2:E2,E2)=1,MIN(IF($A$2:$A$18=E2,ROW($A$2:$A$18)-1)),MAX(IF($A$2:$A$18=E2,ROW($A$2:$A$18)-1))))
copy down

Perfect Ghozi Alkatire! Thank you Sir.

Thank you also FlameRetired.