Hi Everyone,
I am trying to create a spreadsheet to work with my timer. At the moment my timer is ok and i can lap it and send the data to the active cells. My issue is that the amount of rows is varying. I write a number in the first column from one to however many i have. Im a bit stuck because when i get to the bottom its keeps going.
I was wondering if there is a way to check if the 1st column is empty and then start over at the top in the next column and then work my way down again. then do this over again until i get to 10 instances.
Thank you in advance for any help or advice
Here is an example of my spreadsheet of data
<tbody>
</tbody>
When i get to the bottom i want it to go back up to one in the next column
I am trying to create a spreadsheet to work with my timer. At the moment my timer is ok and i can lap it and send the data to the active cells. My issue is that the amount of rows is varying. I write a number in the first column from one to however many i have. Im a bit stuck because when i get to the bottom its keeps going.
I was wondering if there is a way to check if the 1st column is empty and then start over at the top in the next column and then work my way down again. then do this over again until i get to 10 instances.
Thank you in advance for any help or advice
Here is an example of my spreadsheet of data
| 1 | 75 | |||||||||
| 1 | 00:28 | |||||||||
| 2 | 85 | |||||||||
| 2 | 00:56 | |||||||||
| 3 | 95 | |||||||||
| 3 | 00:45 | |||||||||
<tbody>
</tbody>
When i get to the bottom i want it to go back up to one in the next column
Last edited:
