Thread: DUPLICATE RANKS
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matthew
 
Posts: n/a
Default DUPLICATE RANKS

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