Hi,
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:
<colgroup><col><col></colgroup><tbody>
</tbody>
Would greatly appreciate help with this. Thank you,
Alfie101
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