| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unique count formula
Would someone please explain to me how this formula works?
=SUMPRODUCT(($A$2:$A100=1)/COUNTIF($B$2:$B$100,$B$2:$B$100)) Regions are in columns A, and Social Security Numbers are in column B This formula returns the unique number of SSN's in a given region (in this case, region 1). Thanks in advance Daniel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up a formula to count only unique items in a column? | Excel Worksheet Functions | |||
| Attempting to sort unique/only count first record in each unique g | Excel Discussion (Misc queries) | |||
| Count unique text | Excel Worksheet Functions | |||
| How do I set up a formula to count only unique items in a column? | Excel Worksheet Functions | |||
| How to count unique values? | Excel Worksheet Functions | |||
Threaded Mode
