Hi,

I have a column of 3840 rows that have listed reference numbers that contain characters and numbers and might have duplicates within the column.
I need to count how many I have unique references that start with C121.
Please help!!!

example of references listed in the column: C121-xxx-1x-xxx-x111-11111

range 'C510'!D19:D3657