Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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: 1989) 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