Ok here goes...

(Put your list of criteria in Sheet2!Z1:Z10 for this example - obviously you

can change that reference to whatever you need.)

In Sheet2!A1

=IF($Z$1="","-",$Z$1)

in Sheet2!A2

=IF($A1="-","-",

IF(COUNTIF(Sheet1!$A$1:$A$50,$A1)>COUNTIF($A$1:$A1,$A1),$A1,

IF(MATCH($A1,$Z$1:$Z$10)=COUNTA($Z$1:$Z$10),"-",

INDEX($Z$1:$Z$10,MATCH($A1,$Z$1:$Z$10,0)+1))))

in Sheet2!B1:B2

=IF($A1="-","-",

INDEX(Sheet1!B$1:B$50,LARGE(INDEX((Sheet1!$A$1:$A$50=$A1)*

(ROW(Sheet1!$A$1:$A$50)-CELL("ROW",Sheet1!$A$1:$A$50)+1),),

COUNTIF(Sheet1!$A$1:$A$50,$A1)+1-COUNTIF($A$1:$A1,$A1))))

Copy A2:B2 down as far as required, then copy B2:Bx to C2:Cx (or, for other

purposes, as far across as required).

I suspect these could be simplified further, especially if that second one

was re-created as an array formula (which I prefer to avoid where possible),

but my eyes are starting to itch, so I'm off to bed. Night!

HTH

Steve D.