unique list

[miller_ilya]

Hey guys quick question- i have a sheet attached- what i ultiamtely need is a unique list in column D that gives me all the securities from column a where column b = A1.

Thanks in advanceupload_forum_list.xlsx

[Tony Valko]

Based on your sample file...

This array formula** entered in G4:

=IFERROR(INDEX(A:A,SMALL(IF(B$4:B$31=A$1,ROW(B$4:B$31)),ROWS(G$4:G4))),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy down until you get blanks.

[sktneer]

Another way to do this. Pls see the attached workbook.

[miller_ilya]

You guys never disappoint- thank you both

[Tony Valko]

You're welcome. Thanks for the feedback!