Alphabetical order with duplicates

[Berna11]

Good morning
I would like some help to sort names and bring them back from column C
Sheet2 to column C sheet1 also with duplicates.
Then, also report their code from colona B
sheet2 to column B Sheet1
Thanks

[XLent]

based on your sample, and assuming XL2007 compatibility required, one option:

Please Login or Register  to view this content.

[Berna11]

Thank you but, I'm finding some trouble adapting it
The file was just a small example.
Reporting the formula to another file does not sort correctly and leaves some lines empty
I can also use 2010

[Glenn Kennedy]

A 2010-friendly version. In B5:

=IFERROR(INDEX(Foglio2!C:C,AGGREGATE(15,6,ROW(Foglio2!$D$5:$D$29)/(Foglio2!$D$5:$D$29=C5),COUNTIF($C$5:C5,C5))),"")

and in C5:
=LOOKUP(1,0/FREQUENCY(ROWS(C$4:C4),COUNTIF(Foglio2!$D$5:$D$29,"<="&Foglio2!$D$5:$D$29)),Foglio2!$D$5:$D$29)&""

[Berna11]

Ok perfect thanks it works

[Glenn Kennedy]

You're welcome and thanks for the rep.