Count Unique Occurrences
 

I have multiple Criteria to count occurrences on. For example,

Division Store_Name
011 01100002 Irmo
011 01100006 MYRTLE BEACH
011 01100012 FOREST ACRES
011 01100016 Myrtle Beach
011 01100016 Myrtle Beach
011 01100016 Myrtle Beach
014 01400277 Ft. Mitchell
014 01400304 Cincinnati
014 01400305 Cincinnati
014 01400305 Cincinnati
014 01400305 Cincinnati

How do I say that there were 4 unique views at division 011 and 3
unique views at division 014?

Thanks in advance

Brandon Galindo

Count Unique Occurrences
 

=SUM(N(FREQUENCY(IF(Division=11,MATCH(Store_Name,S tore_Name,)),MATCH(Store_Name,Store_Name,))0))

ctrl+shift+enter, not just enter


"Brandon G." wrote:

I have multiple Criteria to count occurrences on. For example,

Division Store_Name
011 01100002 Irmo
011 01100006 MYRTLE BEACH
011 01100012 FOREST ACRES
011 01100016 Myrtle Beach
011 01100016 Myrtle Beach
011 01100016 Myrtle Beach
014 01400277 Ft. Mitchell
014 01400304 Cincinnati
014 01400305 Cincinnati
014 01400305 Cincinnati
014 01400305 Cincinnati

How do I say that there were 4 unique views at division 011 and 3
unique views at division 014?

Thanks in advance

Brandon Galindo

Count Unique Occurrences
 

Another...

=SUMPRODUCT((Division=11)/COUNTIF(Store_Name,Store_Name))


"Brandon G." wrote:

I have multiple Criteria to count occurrences on. For example,

Division Store_Name
011 01100002 Irmo
011 01100006 MYRTLE BEACH
011 01100012 FOREST ACRES
011 01100016 Myrtle Beach
011 01100016 Myrtle Beach
011 01100016 Myrtle Beach
014 01400277 Ft. Mitchell
014 01400304 Cincinnati
014 01400305 Cincinnati
014 01400305 Cincinnati
014 01400305 Cincinnati

How do I say that there were 4 unique views at division 011 and 3
unique views at division 014?

Thanks in advance

Brandon Galindo

Count Unique Occurrences
 

On Aug 11, 11:40*pm, Teethless mama
wrote:
=SUM(N(FREQUENCY(IF(Division=11,MATCH(Store_Name,S tore_Name,)),MATCH(Store_*Name,Store_Name,))0))

ctrl+shift+enter, not just enter



"BrandonG." wrote:
I have multiple Criteria to count occurrences on. *For example,

Division * Store_Name
011 * * * *01100002 Irmo
011 * * * *01100006 MYRTLE BEACH
011 * * * *01100012 FOREST ACRES
011 * * * *01100016 Myrtle Beach
011 * * * *01100016 Myrtle Beach
011 * * * *01100016 Myrtle Beach
014 * * * *01400277 Ft. Mitchell
014 * * * *01400304 Cincinnati
014 * * * *01400305 Cincinnati
014 * * * *01400305 Cincinnati
014 * * * *01400305 Cincinnati

How do I say that there were 4 unique views at division 011 and 3
unique views at division 014?

Thanks in advance

BrandonGalindo- Hide quoted text -

- Show quoted text -

What does Sum(N mean?