Assuming that A2:B8 contains your data, try the following...

In D2, enter: 7

In E2, enter:

=COUNT(1/FREQUENCY(IF(B2:B8=D2,A2:A8),IF(B2:B8=D2,A2:A8)))

....confirmed with CONTROL+SHIFT+ENTER.

In F2, leave empty

In G2, enter and copy across:

=IF(COLUMNS($G2:G2)<=$E2,INDEX($A$2:$A$8,MATCH(0,I F($B$2:$B$8=$D2,COUNTIF
($F2:F2,$A$2:$A$8)),0)),"")

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article ,
Rothman wrote:

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)