many thanks I'll give this a try

"Carim" wrote:

Hi Malcolm,

What you are after is only possible with an array formula ( Control
Shift Enter ), starting in row 2 of your second worksheet :

=IF(ROWS(B$2:B2)<=COUNTIF(Data!$A$2:$A$21,$A$2),IN DEX(Data!$B$2:$B
$21,SMALL(IF(Data!$A$2:$A$21=$A$2,ROW(Data!$A$2:$A $21)-ROW(Data!$A
$2)+1),ROWS(B$2:B2))),"")

Assumption is that your data is located is located in sheet called
Data, area is A1:B21 and field names are in row 1 ...

HTH