Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I find duplicate rows in a list in Excel, and not delete it | Excel Discussion (Misc queries) | |||
Duplicate Disaster | Excel Discussion (Misc queries) | |||
Keeping duplicate rows | Excel Worksheet Functions | |||
Showing Duplicate Rows | Excel Discussion (Misc queries) | |||
Duplicate records in Excel | Excel Discussion (Misc queries) |