| Home |
| Search |
| Today's Posts |
|
#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? |
| 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) | |||
Threaded Mode
