T
Terry
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
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