OK

Altered range A49:AN49, to A49:AT49, WHICH GOES TO THE END OF THE
SEASON.Reason not incl. previous as there were no scores in the "missing"
cols. which works on dates played.
AW Col. is: IF(ISNUMBER(AV4),RANK(AV4,$AV$4:$AV$51),"")
If I may show the formula for the link SS table as follows:

5 columns..
Col. 1: fixed input of places from 1st thro' 8th.
Col. 2: INDEX(Main!$A$4:$A$51,MATCH(D5,Main!$AV$4:$AV$51,0 ))
Col. 3: LARGE(Main!$AV$4:$AV$51,ROW(1:1))
Col. 4: LOOKUP(C5,Main!$A$4:$A$51,Main!$AU$4:$AU$51)
Col. 5: LOOKUP(C5,Main!$A$4:$A$51,Main!$AY$4:$AY$51)

AY Col. is number of wins.

HTH

Regards
Terry
"T. Valko" wrote in message
...
IF(AND(ISNUMBER(AU49),AU49=25),SUM(LARGE(A49:AN4 9,ROW($A$4:$A$51))),IF(ISNUMBER(AU49),"",""))

Not sure what you're trying to do. That formula has a couple of things
wrong with it.

If AU49 is a number =25 then sum the 4th through the 51st largest numbers
(a total of 48 numbers) in the range A49:AN49. The problem is that the
range A49:AN49 is only 40 cells so there can't be 48 numbers to sum.

????

--
Biff
Microsoft Excel MVP


"Terry" wrote in message
...
Win XP Pro sp3
MS office 2003

I am using this formula in an Excel workbook:
IF(AND(ISNUMBER(AU49),AU49=25),SUM(LARGE(A49:AN49 ,ROW($A$4:$A$51))),IF(ISNUMBER(AU49),"",""))







What I want to do is find how many games of 25 or more played by each
player, then if over 25 then take the "best" 25 and give an aggregate.

Within this workbook there is a SS linked to show player with: a) 25 or
more games played. b) If more than 25 played then aggregate the highest
25.



what I have at present is several players played more than 25 games but
in the linked SS the names are mixed up if more than one player has the
same aggregate.



Sorry but it is difficult trying to explain as I am not too familiar with
mixed formulae.



My formulae came from this newsgroup originally.



Please ask if you require more information etc.



Regards



Terry