listing winners formula

[sirdef]

I have a spreadsheet which lists all the points that everybody has won in our poker league is it possible to list say the top 3 highest points from a column
along with the names which are listed in a different column
displaying the current top 3 scorers names elsewhere?
For instance:

name points
ian 2
james 6
fred 7
peter 5

the below is the bit im struggling with
Current leaders are Fred on 7points
james on 6 points
peter on 5 points

any help much appreciated.....

[DCSwearingen]

Have you tried the Data > Filter > (Auto Filter or Advanced Filter) from the data menu?

The Auto Filter has a selection for the Top 10.

Here is what Excel Help has to say on the Advanced Filter:
---------------
Filter a list by using advanced criteria
Your worksheet should have at least three blank rows above the list that can be used as a criteria range. The list must have column labels.

Select the column labels from the list for the columns that contain the values you want to filter, and click Copy .

Select the first blank row of the criteria range, and click Paste .

In the rows below the criteria labels, type the criteria you want to match. Make sure there is at least one blank row between the criteria values and the list.
To see criteria examples, click .

Click a cell in the list.

On the Data menu, point to Filter, and then click Advanced Filter.
Show Me

To filter the list by hiding rows that don't match your criteria, click Filter the list, in-place.
To filter the list by copying rows that match your criteria to another area of the worksheet, click Copy to another location, click in the Copy to box, and then click the upper-left corner of the area where you want to paste the rows.

In the Criteria range box, enter the reference for the criteria range, including the criteria labels.
To move the Advanced Filter dialog box out of the way temporarily while you select the criteria range, click Collapse Dialog .

Tips

You can name a range Criteria, and the reference for the range will appear automatically in the Criteria range box. You can also define the name Database for the range of data to be filtered and define the name Extract for the area where you want to paste the rows, and these ranges will appear automatically in the List range and Copy to boxes, respectively.

When you copy filtered rows to another location, you can specify which columns to include in the copy. Before filtering, copy the column labels for the columns you want to the first row of the area where you plan to paste the filtered rows. When you filter, enter a reference to the copied column labels in the Copy to box. The copied rows will then include only the columns for which you copied the labels.
---------------
To use the links go to your Excel Help file and type in Filter...

[Ron Coderre]

sirdef:

Here's something to work with....

With your list in A1:B5

D1: Place
D2: 1
D3: 2
D4: 3

E1: Name
E2: =INDEX($A$1:$A$5,MATCH(LARGE($B$1:$B$5,D1),$B$1:$B$5,0))
Copy that formula down through E4

Note: that formula cannot differentiate tie scores. If that is an issue let us know.

Regards,
Ron

[Bearacade]

Assuming Column A is name and Column B is points

Highlight Column A and Column B and then click on Data, Sort...
Sort by Points Descending, then by Name Ascending

Then on somewhere else on your sheet put the following (I put it in D1:D4)

D1 is Current leaders are:
D2 is =A2 & " on " & B2 & " points"
D3 is =A3 & " on " & B3 & " points"
D4 is =A4 & " on " & B4 & " points"

[Ron Coderre]

sirdef:

Since I brought up the topic of tie scores, I thought I'd take a shot at handling them....

With your data in A1:B5

D1: Place
D2: 1
D3: 2
D4: 3

E1: Name
E2: =INDEX($A$2:$A$5,SUMPRODUCT(MATCH(SUMPRODUCT(LARGE($B$2:$B$5+0.001*ROW($B$2:$B$5),D2)),$B$2:$B$5+0.001*ROW($B$2:$B$5),0)))

Copy that formula down through E4

ANOTHER ALTERNATIVE....Pivot Table
If you use a Pivot Table, then you can:
Right-Click on the Name field
Check: Advanced Options
Select: Show Top 3

Does either of those options help?

Regards,
Ron