Array formular - Return only unique values

Hi,

I've an array formular where it will returns multiple value. However, i will need it to return only unique values rather than the duplicate values. Could someone please help me with the formular? Thanks in advance. Please find the atatched excel file for further info.

Regards,
Jack

Try changing your formula in B11 to:

=INDEX($B$2:$B$8, SMALL(IF(($A11=$A$2:$A$8)*(IFERROR(MATCH($B$2:$B$8,INDEX(IF($A$2:$A$8=$A11,$B$2:$B$8),0),0),0)=ROW($A$2:$A$8)-ROW($A$2)+1), ROW($A$2:$A$8)-ROW($A$2)+1), COLUMN(A1)))

Confirmed with Ctrl-Shift-Enter

Because this uses the IFERROR function it will not work in versions of Excel prior to 2007.

Thanks both for the advice. The code works well.