Help creating formula for counting unique values

1

Promo        Expected results

12RAD              1

14PAA               1

14PAB               1

14PAB               2

1APAJ                1

1APAK                1

1APAK                2

1APAK                3

How would I go about creating a formula that gives the same results as the Expected results.  Basically I'm trying to count the unique Promotion #'s in the first column and if there are duplicates, it increments by 1.

Answer
Discuss

Answers

1
Selected Answer

A friend helped me figure out the solution that I was seeking

=countif($A$2:A2,A2)

A2 in this example is right under Promo (12RAD)

Discuss

Discussion

Thanks for posting the update! :) Make sure to select it as the answer in a day when you can!
don (rep: 1247) Apr 21, '17 at 5:29 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login