Maybe a better way?

zendog1960

Active Member
Joined
Sep 27, 2003
Messages
449
I am working on a spreadsheet to track my bowling teams scores, averages, wins, losses,best average, high game, etc... I have it working but it seems the formulas is extraordinarily huge. I would like to see is there would be some things I can do to simplify the formulas.

I have about 11 Sheets. I am not going to expect anyone to look over the entire worrkbook but maybe just two sheets as they are the core of the entire woorkbook.

The first sheet is 'Weekly Scores' This is where I input the weeekly scores.
The Second sheet is just one of seven bowlers personal sheet keeping track of each game, and some other stats. This is where the formulas are starting to get crazy and I would like to see if I can cut them down to a more managable size.

Please post your comments and suggestions clearly so I don't end up F-ing up the whole workbook up! LOL

Thanks in advanced:

The two sheets will be posted seperately following this post.
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

zendog1960

Active Member
Joined
Sep 27, 2003
Messages
449

zendog1960

Active Member
Joined
Sep 27, 2003
Messages
449
I knoticed the formulas are not showing completely so here is what is in the second table in call B3:

=IF(ISERROR(INDEX('Weekly Scores'!$A$3:$E$13, MATCH("Jim",'Weekly Scores'!$A$3:$A$13,), MATCH("Game 1",'Weekly Scores'!$A$3:$E$3,))),"-",(INDEX('Weekly Scores'!$A$3:$E$13, MATCH("Jim",'Weekly Scores'!$A$3:$A$13,), MATCH("Game 1",'Weekly Scores'!$A$3:$E$3,))))

What I was trying to do is first to check to see if this bowler bowled that week. If he did not, then a "-" was placed in B#, if he did bowl, then his game one score was placed in B3. This repeats for all 36 weeks, 3 games a week for this and each of the other 6 bowlers.

So you can see this is a huge amount of formulas that I perticularly do not want to input over and over again! LOL
 

zendog1960

Active Member
Joined
Sep 27, 2003
Messages
449
Now that it is the work week, I am hoping someone can help with simplifying the formulas. any suggestions would greatly be appreciated!
 

zendog1960

Active Member
Joined
Sep 27, 2003
Messages
449
Just wanted to get this up at the top of the list so it doesn't get missed by the gurus here! :biggrin:
 

Watch MrExcel Video

Forum statistics

Threads
1,114,188
Messages
5,546,463
Members
410,741
Latest member
Count25
Top