Hi All,
I am trying to create a spreadsheet for a cycling l club I am in. I am trying to build a text string of numbers based on results achieved.
The first one I am trying to do is look up a persons name and their results at a certain location. So for John Smith from the results below I would like a formula that looks at John Smith and Nottingham and gives the answer 3118213.
Secondly I am testing the accuracy of the scores we give. So when John Smith rides at Nottingham and he is given a score greater than 80 what is his results. The answer is 311213.
Does anyone know if this is possible? Thanks for any help.
<colgroup><col><col span="2"><col></colgroup><tbody>
</tbody>
I am trying to create a spreadsheet for a cycling l club I am in. I am trying to build a text string of numbers based on results achieved.
The first one I am trying to do is look up a persons name and their results at a certain location. So for John Smith from the results below I would like a formula that looks at John Smith and Nottingham and gives the answer 3118213.
Secondly I am testing the accuracy of the scores we give. So when John Smith rides at Nottingham and he is given a score greater than 80 what is his results. The answer is 311213.
Does anyone know if this is possible? Thanks for any help.
Name | Location | Score | Place |
John Smith | Nottingham | 87 | 3 |
John Smith | Nottingham | 125 | 1 |
John Smith | Nottingham | 118 | 1 |
John Smith | Nottingham | 36 | 8 |
John Smith | Nottingham | 98 | 2 |
John Smith | Nottingham | 105 | 1 |
John Smith | Nottingham | 85 | 3 |
John Smith | London | 122 | 1 |
John Smith | London | 67 | 5 |
John Smith | London | 61 | 4 |
John Smith | London | 121 | 1 |
John Smith | London | 84 | 3 |
John Smith | London | 19 | 9 |
John Smith | London | 100 | 2 |
Answer Needed 1. Results at Location | |||
John Smith | Nottingham | 3118213 | |
John Smith | London | 1541392 | |
Answer Needed 2. If scored above 80 and Location | |||
John Smith | Nottingham | >80 | 311213 |
John Smith | London | >80 | 1132 |
<colgroup><col><col span="2"><col></colgroup><tbody>
</tbody>