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 collam along with the names which are listed in a different
collem 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.....:)


--
sirdef
------------------------------------------------------------------------
sirdef's Profile: http://www.excelforum.com/member.php...o&userid=35106
View this thread: http://www.excelforum.com/showthread...hreadid=548615

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...


--
DCSwearingen

Getting old, but love computers.
------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=548615

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


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=548615

Assuming Column A is name and Column B is points

Highlight Column A and Column B and then click on _D_ata, _S_ort...
Sort by Points _D_escending, then by Name As_c_ending

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

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


--
Bearacade
------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=548615

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.0 01*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


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=548615