Maybe a better way?

zendog1960

Active Member
Joined
Sep 27, 2003
Messages
453
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.
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

zendog1960

Active Member
Joined
Sep 27, 2003
Messages
453

zendog1960

Active Member
Joined
Sep 27, 2003
Messages
453
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
453
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
453
Just wanted to get this up at the top of the list so it doesn't get missed by the gurus here! :biggrin:
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,032
Messages
5,856,939
Members
431,841
Latest member
jaybeem

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top