Filter by Function

hi arctushar, do upload a sample Excel file next time so that we do not have to re-create your data to test. assuming data in Sheet1, try this in A3 of the other sheet:
=IFERROR(INDEX(Sheet1!A$1:A$20,SMALL(IF(Sheet1!$A$1:$A$20=$A$2,ROW(Sheet1!A$1:A$20)-ROW(Sheet1!$A$1)+1),ROWS(A$3:A3))),"")
...confirmed by pressing CTRL-SHIFT-ENTER to activate the array. 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. Press F2 on that cell and try again.