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.