My data looks like this:

Num1 Num2
56 5
100 7
46 7
46 7
88 7
100 7
75 8

What I need as a result, looking up the value 7 in Num2:

100 46 88 (separate cells in a row)

I found the quoted material (see below) in another post, but that returns:

100 46 46 88 100

Is there anyway to eliminate the duplicates?

> Assumptions:
>
> A1:B5 contains your source data
>
> First row contains your headers/labels
>
>
> Formula:
>
> E2, copied across:
>
> =IF(COLUMNS($E1:E1)<=COUNTIF($A$2:$A$5,$D2),INDEX($B$2:$B$5,SMALL(IF($A$2
> :$A$5=$D2,ROW($A$2:$A$5)-ROW($A$2)+1),COLUMNS($E1:E1))),"")
>
> ....where D2 contains the program name of interest. The formula needs to
> be confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Actually, if you
> need to, you can enter your list of program names in Column D, starting
> at D2, enter the formula in E2, copy across and down.