Extract rows for duplicate K values with AT different Number

Hello Friends

I need to extract the rows for duplicate values in column K but different numbers in column AT. This needs to be done by formula.

Sheet 2 shows the required result.

thanks in advance

Sekar

Please try at Sheet2

Helper AY4
=IFERROR(AGGREGATE(15,6,ROW(Sheet1!$K$3:$K$68)/(COUNTIF(Sheet1!$K$3:$K$68,Sheet1!$K$3:$K$68)>COUNTIFS(Sheet1!$K$3:$K$68,Sheet1!$K$3:$K$68,Sheet1!$AT$3:$AT$68,Sheet1!$AT$3:$AT$68))/(MATCH(Sheet1!$K$3:$K$68&Sheet1!$AT$3:$AT$68,INDEX(Sheet1!$K$3:$K$68&Sheet1!$AT$3:$AT$68,),)=ROW(Sheet1!$K$3:$K$68)-ROW(Sheet1!$K$2)),ROWS(A$4:A4)),"")

A4:AWxx
=IF($AY4="","",INDEX(Sheet1!A:A,$AY4))

Hello Bo_Ry

Thanks for your formula. Working perfect, but i am sorry i missed one requirement. Along with the existing criteria's in Column B for specific text (say AAA) then it should pull the rows.

Kindly refer the attached file.

Thanks again

Sekar

AY4
=IFERROR(AGGREGATE(15,6,ROW(Sheet1!$K$3:$K$68)/(COUNTIF(Sheet1!$K$3:$K$68,Sheet1!$K$3:$K$68)>COUNTIFS(Sheet1!$K$3:$K$68,Sheet1!$K$3:$K$68,Sheet1!$AT$3:$AT$68,Sheet1!$AT$3:$AT$68))/(MATCH(Sheet1!$K$3:$K$68&Sheet1!$AT$3:$AT$68,INDEX(Sheet1!$K$3:$K$68&Sheet1!$AT$3:$AT$68,),)=ROW(Sheet1!$K$3:$K$68)-ROW(Sheet1!$K$2))/(Sheet1!$B$3:$B$68="AAA"),ROWS(AY$4:AY4)),"")

Hello Bo_Ry

Thanks for your formula, working well,

This is saving my time.

Thanks again

Sekar