Hi all,
I've searched help on countif with no luck so far, so I am not sure if I'm on the right track.
I have 714 records with an alpha/numeric reference code in column A. This code may appear several times in that column however I only want to count the first occurrence along with all the unique ones. Ie. The total number of different codes used, whether they appear more than once or not is irrelevent. Hope I have made sense and that someone out there can help. Thanks.
Regards,
Cheryl.
I've searched help on countif with no luck so far, so I am not sure if I'm on the right track.
I have 714 records with an alpha/numeric reference code in column A. This code may appear several times in that column however I only want to count the first occurrence along with all the unique ones. Ie. The total number of different codes used, whether they appear more than once or not is irrelevent. Hope I have made sense and that someone out there can help. Thanks.
Regards,
Cheryl.