I have set up a formula in Excel to record the time for riders in a bike race
who are doing a number of laps. Each time they come over the line I want to
put their race number in to a cell and for Excel to record the time. I have
successfully created a formula to do this (if the value of the cell into
which I put the race number is 0 the time is inserted into another cell).
However, once the time has been inserted I don't want it to change when I put
another race number in to the cell below. Does anyone know how I can do this?
Sarah