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

can you please send me your sheet with this macro enabled i hav to work on something similar

I will look at this later. It might be easier to add a column in your sheet with a formula to calculate the ratio.

Thank you for everything StephenR!

If I may ask for a bit more, is it possible with an array formula to simply copy data to another place?

This is for a new sheet in my workbook,
I need to create a macro that will, once again search for a car number and then a pit number, but then I "simply" needs it to copy all the lap time cells corresponding to a specific column in a third sheet "Stints" and for each pit number to use the next column (so 7*6 columns from B to AQ + column A which has lap number in it)

I have been trying quite a few things this afternoon, from the code you already gave me before and other stuff as well but I either get codes which run indefinitely or zeros all over the sheet.... something is obviously wrong and I cannot find what....


Thank you so much again for all your help

If that is a separate question, it might be better to start a new thread for it.

On your original question, could you add to your attachment some sort of illustration of how the ratio works? I've not had a chance to look at yet, but that may help to expedite matters once I do.

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 )