Extracting multiple unique values from a table based on a single criterion.

Thanks Pete, that is a nice solution.

Unfortunately I need both samples to work at the same time, otherwise I would have to do a lot of manual workarounds in my original spreadsheet.

Cheers,
Al

Well, you could use a second helper column, with this formula in K4:

=IF(F4=$D$26,MAX(K$3:K3)+1,"-")

and this formula in C29:

=IFERROR(INDEX(C:C,MATCH(ROWS($1:1),$K:$K,0)),"")

as the attached file demonstrates.

Hope this helps.

Pete