Matthew,

Not sorted in rank, but I can get you the list

Select E1:E20 (or however many you think you need) and add this formula to
the formula bar

=IF(ISERROR(SMALL(IF($B$1:$B$200,ROW($A$1:$A$20), ""),ROW($A$1:$A$20))),"",
INDEX($A$1:$A$20,SMALL(IF($B$1:$B$200,ROW($A$1:$A $20),""),ROW($A$1:$A$20)))
)

and commit with Ctrl-Shift-Enter.

Then do the same for F1:F20 with this formula

=IF(ISERROR(SMALL(IF($B$1:$B$200,ROW($A$1:$A$20), ""),ROW($A$1:$A$20))),"",
INDEX($B$1:$B$20,SMALL(IF($B$1:$B$200,ROW($A$1:$A $20),""),ROW($A$1:$A$20)))
)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Matthew" wrote in message
...
I have the following data table :-

NAME POINTS RANK
Adrian 0 5
Billy 0 5
Carl 23 1
Des 4 3
John 4 3
William 6 2
Hazel 0 5

The actual table is a lot bigger than this but it gives the gist of what I
need.

Basically I want to extract the names of everyone with more than 0 points
in
one column, and the points each person has in the next column (Ranked in
order if possible).

Cheers