Hi,

I have a column of 3857 rows that have listed numbers that contain characters and might have duplicates.
I need to count how many I have unique numbers that start with C121 and how many start with C510. Two functions.
As I understand it should be COUNTIF. Please help!!!

example of numbers in the column: C121-xxx-1x-xxx-x111-11111 and C510-xxx-1x-xxx-x111-11111

range D1:D3657