I've attempted something but haven't come up with the same averages as you, which may mean I haven't fully understood.
In the first sheet of the attachment I've added a formula in cols M-O (for each of the sectors) which puts a 1 for the first lap of each driver and also if any lap time is more than 1.2 times the previous one.
I've then amended the array formula in the code to exclude any 1s in those columns.
Where have I gone wrong?
Bookmarks