View Single Post
  #8   Report Post  
Ola
 
Posts: n/a
Default

...if it should be 6...

Group Count:
=SUM(--(A1:A8&B1:B8<A2:A9&B2:B9))+1
=6

Ola

Note:
Confirm the formula by holding down Ctrl and Shift, and then press Enter.
Otherwise the result will be 1.