• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional numbering


What formula can I use to get the result in column A, as shown below:

Col-A Col-B

1 B-001 if it is unique

2 B-001 if it is repeated

1 B-003 if it is unique

2 B-003 if it is repeated

3 B-003 if repeated again

Thanks in advance.
Another related question :

What if I need sum count against 2 columns ?

Col1 Col2 ID
A B AB001
A C AC001
A B AB002

Is there any cross-product function doing the job ?

Thanks in advance

Cyril Z.

try this in C1 and copy down

An alterntive if you have 2007 is the COUNTIFS formula: