Is there a formula to count occurrences of consecutive text in a lengthy file, and put the number in an adjacent column, as in the sample below:

019DAEA5-7213-4CA8-A421-C8E6696CFE10 | 3 |

019DAEA5-7213-4CA8-A421-C8E6696CFE10 | 3 |

019DAEA5-7213-4CA8-A421-C8E6696CFE10 | 3 |

019DDD1C-3563-4A32-AEDB-7109DD5C7FD2 | 2 |

019DDD1C-3563-4A32-AEDB-7109DD5C7FD2 | 2 |

01C8BF3D-217F-4219-ABE2-AD8D779BDC8C | 5 |

01C8BF3D-217F-4219-ABE2-AD8D779BDC8C | 5 |

01C8BF3D-217F-4219-ABE2-AD8D779BDC8C | 5 |

01C8BF3D-217F-4219-ABE2-AD8D779BDC8C | 5 |

01C8BF3D-217F-4219-ABE2-AD8D779BDC8C | 5 |

<colgroup><col><col></colgroup><tbody>

</tbody>

Would greatly appreciate help with this. Thank you,

Alfie101