One way using non array formulae ..

Assume source table is in A1:C8

Put in D2: =IF(B20,C2+ROW()/10^10,"")
(Leave D1 empty)

Put in E2:
=IF(ISERROR(SMALL(D:D,ROW(A1))),"",
INDEX(A:A,MATCH(SMALL(D:D,ROW(A1)),D:D,0)))

Put in F2: =IF(E2="","",VLOOKUP(E2,A:B,2,0))

Select D2:F2, copy down until the last row of data
Cols E and F will return the desired results
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"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