Apr 12 2022 08:39 AM
I have a table exported from the Motec i2 telementery software which states the start and finishing distance (cumulative) for some select corners and the sections between them.
In the table I have started below, I want to summarise this data in a more condensed form. For example for cell B10 (which shows the start of lap 1 turn 1) this should look in the table above and extract the cell where the column contains values "Lap 1" and "Start" and the row contains "Start". Is there a way I can do this?