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
Hi there. this should do the trick...
=COUNTIF('C510'!D19:D3657,"C121*")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
It must be "uniques day" !
So, you want to count the unique entries that start with C121?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Oh... I misread your post. Disregard my earlier reply.
yes, I need to count unique values that start with C121
Try this...
Data Range
This array formula** entered in B2:
=SUM(IF(FREQUENCY(IF(LEFT(A2:A10,4)="C121",MATCH(A2:A10,A2:A10,0)),ROW(A2:A10)-ROW(A2)+1),1))
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Thank you very much Tony!!! That works perfectly and saves me a lot of time
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks