T
Terry
Win XP Pro
MS-Office XP
I have a workbook with a spredsheet showing bowling scores from other
sheets in the workbook, with much appreciated help from this NG.
The scores are in ROWS, with up to 50 scores per season.
What I wish to do is automate where In a cell at the end of each row it will
show the highest 25 scores per player...If not played 25 games then text to
show "NQ" (meaning not qualified).
The highest 25 scores will be in aggregate form and not average.
The actual scores will range from 1 to 40 each game.
The number of rows may be up to 40.
Also on this sheet are columns with date of each match.
Hope I have explained OK?
Regards
Terry
MS-Office XP
I have a workbook with a spredsheet showing bowling scores from other
sheets in the workbook, with much appreciated help from this NG.
The scores are in ROWS, with up to 50 scores per season.
What I wish to do is automate where In a cell at the end of each row it will
show the highest 25 scores per player...If not played 25 games then text to
show "NQ" (meaning not qualified).
The highest 25 scores will be in aggregate form and not average.
The actual scores will range from 1 to 40 each game.
The number of rows may be up to 40.
Also on this sheet are columns with date of each match.
Hope I have explained OK?
Regards
Terry