Formula for getting duplicate values on data validation

[RAMU]

Dear Friends,

I have a sheet "supplier".
In sheet 2 I am inputting the following array formula:

{=IFERROR(INDEX(supplier!$B$2:$B$4377,MATCH(0,IF(supplier!$A$2:$A$4377=$G$9,COUNTIF($G$10:G10,supplier!$B$2:$B$4377)),0)),"")}

The formula is given from G11 to G23 by which data are snatched from "supplier" sheet. By this formula here duplicate values are ignored.

G9 cell is data validated.

Now I want that duplicate values will be shown in G11 to G23 or more as it is which are available in column B of "supplier" sheet.

Kindly help.

Regards
RAMU

 

[Peter_SSs]

In sheet 2 cell G11, try this formula (not array entry) and copy down.

=IFERROR(INDEX(supplier!$B$2:$B$4377,AGGREGATE(15,6,(ROW(supplier!$B$2:$B$4377)-ROW(supplier!$B$2)+1)/(supplier!$A$2:$A$4377=$G$9),ROWS(G$11:G11))),"")