| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting values ignoring duplicates
Hi there,
I am trying to count the number of values in a column (A2:A217) ignoring duplicated values. As an eg, applying this to the data below I would expect the count value to be 3. Please can anyone help, many thanks, Matt 00013270 00018038 00018038 00018038 00018038 00018038 00018038 00018038 00018038 00018038 00018038 00023049 00023049 00023049 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting the cells ignoring zero values | Excel Discussion (Misc queries) | |||
| Counting Unique Values with Duplicates | Excel Discussion (Misc queries) | |||
| counting function but not double counting duplicates | Excel Worksheet Functions | |||
| Counting Names in a Column, Ignoring Duplicates | Excel Discussion (Misc queries) | |||
| average values in non-contiguous cells, ignoring 0 values | Excel Worksheet Functions | |||
Threaded Mode
