Hi
I have attached below a sample of the data I am trying to analyse. Could anyone recommend a formula (or 3) which would return the date of the first occurrence of the text in column A, the last occurrence of the same, and the number of occurrences in total? They are sorted in the alpha numeric sequence. The ultimate aim is to find the length of time (months) between the first and last occurrence, and the number of occurrence for each contract number.
Many thanks in advance.
Kind regards
Andrea
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
I have attached below a sample of the data I am trying to analyse. Could anyone recommend a formula (or 3) which would return the date of the first occurrence of the text in column A, the last occurrence of the same, and the number of occurrences in total? They are sorted in the alpha numeric sequence. The ultimate aim is to find the length of time (months) between the first and last occurrence, and the number of occurrence for each contract number.
Many thanks in advance.
Kind regards
Andrea
<colgroup><col span="2"></colgroup><tbody> </tbody> |
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>