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

nowhere
it was the ratio I gave you.... oops it is more 1.015 or so than 1.2... 1.2 was not excluding all the laps manually excluded in the other attachment.

sorry for the trouble...

was it not possible to just add a condition in the formula array instead of having to add those columns?

Thinking about that makes my head hurt. Some of the formula whizzes here may be able to, but afraid it's beyond me.

What I could do is add and then remove the formulae in the code so it's all automated.

it's fine don't worry
thanks for everything again