87000km 2007
I switched the coil from 1 to 5(other side of the engine on the front) I wonder if I would have a different code if I changed it with number 3?? 5 does fire right after 1.
That might be an interesting test. Thanks for that info.

I have BMWhat app for android and Dash Commander for reading codes

BMWhat has a section under Parameter that has a "Running unrest filtered"
for each cylinder. Values varied for each cylinder evenly across the 8 cylinders. Not sure what the values should be but they all seemed the same 0-181/sec.

If I let the car idle in the morning for 2 minutes the misfire doesn't occur.