| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count names and occurrences | Excel Worksheet Functions | |||
| Unique occurrences of a value Q | Excel Worksheet Functions | |||
| trying to COUNT occurrences when certain criteria is met | Excel Discussion (Misc queries) | |||
| Count number of occurrences | Excel Discussion (Misc queries) | |||
| Count unique occurrences of name | Excel Discussion (Misc queries) | |||
Hybrid Mode
