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,IF($B$2:$B$8=$D2,COUNTIF
($F2:F2,$A$2:$A$8)),0)),"")

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

Hope this helps!

In article <D9EB6883-5C68-428B-8FCA-E5372654A08A@microsoft.com>,
Rothman <Rothman@discussions.microsoft.com> 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)