| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count unique in non-continuous list
Hi,
Is there a way to count unique values in a list that is not continuous and contains merged cells? I have a list in one column which regroups data (numbers) in several categories and each value can occur in several categories. And there are merged cells as well. How to count the unique entries over the entire list? The functions mentioned in the numerous posts here do not seem to work. Thanks, Hans |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Unique Values from a Subset of a List | Excel Discussion (Misc queries) | |||
| how can i count the number of unique names in a list | Excel Discussion (Misc queries) | |||
| Charting count of unique dates in a list | Charts and Charting in Excel | |||
| count unique items in ever-growing list? | Excel Discussion (Misc queries) | |||
| List Unique Occurences and Count | Excel Worksheet Functions | |||
Threaded Mode
