terrykalaka
New Member
- Joined
- Sep 10, 2014
- Messages
- 6
Hey Gang,
Long time lurker, first time poster here! I've searched around a for a couple of days to try to figure out my deal here, but haven't been able to find a solution, so here goes.
The problem I'm working on is for creating start lists for a cycling event. We start with a Sign In worksheet like this:
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
The TT and IP columns are the two different events, x in each of columns G and H column for riders signing up for that particular event. From that, we create a start/time sheet using formula:
=IF('Sign In'!G2="","",'Sign In'!C2)
To get this Start List worksheet:
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Everything works great on that part, except for the blank cells that are left from riders in the original Sign In sheet not doing a particular event. Right now, we manually go through all of the lists and remove the blank cells. This is where I'd like to automate that process, so that in the case that the IF statement returned a blank cell, that it would read the next cell from the Sign In sheet until it returned an actual value. What do you guys think?
Long time lurker, first time poster here! I've searched around a for a couple of days to try to figure out my deal here, but haven't been able to find a solution, so here goes.
The problem I'm working on is for creating start lists for a cycling event. We start with a Sign In worksheet like this:
A | B | C | D | E | F | G | H | |
1 | No. | Name | Lic # | Cat. | State | TT | IP | |
2 | 1 | 96 | John Stevenson | 58245 | 1 | GA | x | x |
3 | 2 | 68 | Steven James | 23654 | 3 | GA | x | |
4 | 3 | 10 | Don Johnson | 44038 | 4 | GA | x | |
5 | 4 | 32 | Chad Christie | 64573 | 2 | GA | x | x |
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
The TT and IP columns are the two different events, x in each of columns G and H column for riders signing up for that particular event. From that, we create a start/time sheet using formula:
=IF('Sign In'!G2="","",'Sign In'!C2)
To get this Start List worksheet:
A | B | C | D | E | |
1 | Heat | Start Position | No. | Men's 1000m TT | Time |
2 | 1 | Front | 96 | John Stevenson | |
3 | Back | | |||
4 | 2 | Front | 10 | Don Johnson | |
5 | Back | 32 | Chad Christie | ||
6 | |||||
7 | Heat | Start Position | No. | Men's 4k IP | Time |
8 | 1 | Front | 96 | John Stevenson | |
9 | Back | 68 | Steven James | ||
10 | 2 | Front | |||
11 | Back | 32 | Chad Christie |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Everything works great on that part, except for the blank cells that are left from riders in the original Sign In sheet not doing a particular event. Right now, we manually go through all of the lists and remove the blank cells. This is where I'd like to automate that process, so that in the case that the IF statement returned a blank cell, that it would read the next cell from the Sign In sheet until it returned an actual value. What do you guys think?