Quote Originally Posted by Fluff13 View Post
How about
In G4 copied down
Formula: copy to clipboard 
=IF(E4="","",COUNTIFS(A:A,E4))
and in H4 copied down & across
Formula: copy to clipboard 
=IFNA(INDEX($C$4:$C$50,MATCH($E4&"|"&H$3,$A$4:$A$50&"|"&$B$4:$B$50,0)),"")
The H4 formula needs to be confirmed with Ctrl Shift Enter before dragging down & across
That formula will result in the total number of stops, being the value calculated in column G. Sadly that was not what I was looking for. I am interested in how to get the laps (col. C) into col. G-L.