macro to create pivot table(s) and sort out data in other worksheet

ok I will do sorry.

for the ratio:

the code you gave me does the average of the sector times.

However some values are too high to be representative of the cars' performances: it happens during out laps (the car leaves the pit lane) and during the safety car laps when the cars are all queued up behind the safety car, driving slowly for safety reasons (debris on track, crashed car in the way...)
so I would like to take those values out of the average.

Until now all the analysis was done manually so I was just choosing which laps to ignore or take.

because slow is dependent on the circuit and type of racing you are doing, I cannot put a value on it.
so I had in mind to compare values with each other.
ignoring the very first lap available for each car (too slow) I imagined each value could be compared to the previous one and if about similar (inferior to the value * a ratio I need to define) it would be included in the average, otherwise ignored.

usually a safety car is about slower by a third of a lap time but it varies a little and out laps are usually faster than safety cars. That's why I came up with a 1.2 ratio with no calculations done for now, I can adjust the value later easily.

I looked at some info on array formulas and I have seen conditions of inferiority/superiority in them but when I tried it did not really work... I think there are just too many things in the arguments and I have not yet completely understood it.

I have attached the manual workbook so you can see a bit what was done.

(it also shows everything else I still need to make automatic )