Hi
I could not copy the entire portion of the work sheet as it was to big, so I copied the first few lines and the last two lines of where my questions reside.
Question 1. How to get rid of the value errors in rows a04:at27. Only the bottom two rows are showing (assuming the copies make it to this post). I believe it is due to the fact that scores are being computer at the bottom (k26:at27) when not all the rows above them have had data put in them
Question 2. Columns b4:i27 show the possible points awarded relative to the position they finish (B3:i3). I need to determine which events have already been completed (k4:u5 in this example) and list how many possible points are left to win for each school (k2:u2).
A running total of each school is in ao28:at28
As I mentioned, I could not attach the entire worksheet in the copy, but hopefully attaching the top portion and bottom portion will be enough for you "Excel guys (and gals) to run with.
Anyway, hope the attachemnts make it to this post.
And more importantly, I hope you all understand what I am trying to accomplish.
Now bottom Portion:
I could not copy the entire portion of the work sheet as it was to big, so I copied the first few lines and the last two lines of where my questions reside.
Question 1. How to get rid of the value errors in rows a04:at27. Only the bottom two rows are showing (assuming the copies make it to this post). I believe it is due to the fact that scores are being computer at the bottom (k26:at27) when not all the rows above them have had data put in them
Question 2. Columns b4:i27 show the possible points awarded relative to the position they finish (B3:i3). I need to determine which events have already been completed (k4:u5 in this example) and list how many possible points are left to win for each school (k2:u2).
A running total of each school is in ao28:at28
As I mentioned, I could not attach the entire worksheet in the copy, but hopefully attaching the top portion and bottom portion will be enough for you "Excel guys (and gals) to run with.
Anyway, hope the attachemnts make it to this post.
And more importantly, I hope you all understand what I am trying to accomplish.
| Excel Workbook | ||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | AS | AT | |||
| 1 | Current overall points standings: | 1 | 1 | 3 | 3 | 3 | 3 | |||||||||||||||||||||||||||||||||||||||||
| 2 | Points for finishing ranked | JE | MC | ## | ## | ### | ## | ## | ## | ## | ## | ## | Points won in each lane | Who placed | Running total points | |||||||||||||||||||||||||||||||||
| 3 | Event | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | JENSEN | MARTIN | |||||||
| 4 | 200 Yard Medley Relay B | 8 | 4 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 8 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | JENSEN | MARTIN | 8 | 4 | 0 | 0 | 0 | 0 | ||||||||||||||||||
| 5 | 200 Yard Medley Relay G | 8 | 4 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 4 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | MARTIN | JENSEN | 12 | 12 | 0 | 0 | 0 | 0 | ||||||||||||||||||
| 6 | 200 Yard Free B | 6 | 4 | 3 | 2 | 1 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||
| 7 | 200 Yard Free G | 6 | 4 | 3 | 2 | 1 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||
| 8 | 200 Yard Ind Medley B | 6 | 4 | 3 | 2 | 1 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||
Enter Swim Scores | ||||||||||||||||||||||||||||||||||||||||||||||||
Now bottom Portion:
| Excel Workbook | ||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | AS | AT | |||
| 23 | 100 Yard Breaststroke G | 6 | 4 | 3 | 2 | 1 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||
| 24 | 400 Yard Free Relay B | 8 | 4 | 2 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||
| 25 | 400 Yard Free Relay G | 8 | 4 | 2 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||
| 26 | Diving Boys | 6 | 4 | 3 | 2 | 1 | 0 | 0 | 0 | 1 | 2 | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | |||||||||||||||||||||||||||||||
| 27 | Diving Girls | 6 | 4 | 3 | 2 | 1 | 0 | 0 | 0 | 2 | 1 | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | |||||||||||||||||||||||||||||||
| 28 | Lane Assignments | JENSEN | MARTIN | JENSEN | MARTIN | 12 | 12 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
Enter Swim Scores | ||||||||||||||||||||||||||||||||||||||||||||||||
