# Maybe a better way?

#### zendog1960

##### Active Member
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

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
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
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
Just wanted to get this up at the top of the list so it doesn't get missed by the gurus here!

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.

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.

### Which adblocker are you using?

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

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