Extract Data from one to another using conditions

Will Formula will do?

Thank you for your reply. I was looking for macro solution, because then it can work with more than 50/90,000 of dataset, but I can use formula, if that is quicker solution.

Many thanks.

Pl see attached file.

Thank you so much for your reply. I am sorry to inform, that the formula, should extract only duplicate names which have occurred 3 time or more.

In the post #4, the only names that should be displayed in sheet2, are CORDR 4 and ESAIL, with their calculations, otherwise the other names are incorrect.

is it possible to change the formula, if its not too much trouble.

Thank you for all your help.

Pl see attached file with changed formula.

Thank you so much for your help and update. The solution is great, but I am trying to update the formula(name column -- sheet2) to read 50,000 records but every time I edit this, the cell goes blank.

=IFERROR(INDEX(Sheet1!$A$2:$A$50000,SMALL(IF((COUNTIF($A$1:$A7,Sheet1!$A$2:$A$1000)=0)*(COUNTIF(Sheet1!$A$2:$A$50000,Sheet1!$A$2:$A$50000)>2),ROW($A$2:$A$50000),""),1)-1),"")

I have also tried, editing the formula out of the cell and then pasting in the new chnages, it still gives me a blank cell.

Please advice, if possible.
Many thanks.

It is Array formula. After editing the for mula , Don't press Enter key.
Press Ctrl+Shift+Enter keys together.

Many thanks for your help again. I followed your directions, and sadly the macro is outputting the cells as 0. I have attached my dataset in sheet1 and sheet2, has the formulas, which are currently not reading any data from sheet1.

extraction_formula.xls

Thanks you for your time and help.

PL see attached file.